Skip to Content
0
Former Member
Jun 28, 2011 at 04:38 PM

Accounting for hours in a workorder by month when workorder spans multiple

16 Views

Hello, I have a crystal report that tracks equipment downtime/availability. The report selects records for the past year and sorts them by month, I need to calculate the monthly downtime hours and equipment availability for each piece of equipment. Works fine when the start date and end date are in the same month. If the end date spans 1 or more months I have calculated the hours for that month in which the recored started. But how do I account for the hours in the next month (s). ie

Jul

WO#--


Startdate
Enddate
--


Total hours

1--


2010-07-09 10:00
2010-07-27 17:24
--


439.4

2--


2010-07-30 15:50
2010-09-23 12:29
--


8.17

In the above WO#1 is started and ends in the same month - no problem

WO#2 starts in Jul but ends in Sep, I've calculated the hours to the end of Jul but what about the hours in Aug and Sep.

Can I have the WO show up in different months if the end date spans more than one month. or how would I account for the hours in Aug and Sep?

Any suggestion appriciated.