Calculating manhours

[Reaper]

I have three fields named:



StartTime (Short Time)
EndTime (Short Time)
LaborCount (Long Integer)

LaborCount is the number of persons assigned to an activity.

I want to calculate the total man-hours for the activity.

My current expression is: (EndTime-StartTime)*LaborCount

The start and end times correctly calculate, but the final calculation
comes out wrong. For example, (8:00) times 12 (laborcount) comes out as
15:00.

I wanted it to be 96:00, but kind of expected it to come out to 0:00 as this is an exact multiple of the 24 hour day. The 15:00 really thru me off.

Suggestions?

[June7]

I just learned a new intrinsic function.

TimeValue("8:22")*24*12 will return 100.4, the total hours in decimal hours.

So your expression would be like TimeValue(EndTime-StartTime)*24*LaborCount).

If you want to convert back to hours:minutes, something like:

Int(DecTime) & ":" & Int((DecTime-Int(DecTime)) * 60)

Or

Int(DecTime) & ":" & Round((DecTime-Int(DecTime)) * 60,0)

Be aware Round use even/odd rule.