Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Downtime Calculation

Status
Not open for further replies.

lyordan

Electrical
Joined
Jun 7, 2003
Messages
1
Location
US
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?
 
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.
[sunshine]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top