Downtime Calculation

[lyordan]

I've just moved from one job to another. In my previous job, we would use Maximo as our maintenance software, but in my new job what is available is MP2 from Datastream. I was very disappointed on a Datastream seminar yesterday to find out that the software does not calculate downtime automatically. I've been trying to develop a downtime formula that will allow me to do that either internally (our MP2 version is on Access 2000 platform) or externally, but it has to have the flexibility to specify the amount of shifts used and the amounts of days in the week. For the amount of shifts, its straightforward:

((Date and Time downtime started)-(Date and time finished))/4-(number of shifts)

This formula would compute downtime in hours and would be corrected by shift. How do I integrate days-of-week correction to this? Can anyone out there help?

 

[Drazen]

I have no straight idea hoe do you plan to calculate downtime. In Maximo, you could enter beginnining and end time od downtime, and Maximo would count only working hours, based on calendars you set, isn't it. If you don't have this feature in MP2, it seems that you need to subtract all nonwoking hours from total time elapsed. After you've done this, you can simply divide dowtime hours with number of hours in one shift to get number of downtimed-shifts.