I'm not sure about your formula for elapsed time. If the time fields are Time fields and on the same date, I use (EndTime-StartTime)/3600 to convert to hours and fraction of hours. The second ConvertToFraction is not needed.
If the time will run across several days, then I would use a custom function. A good source for these is http://briandunning.com.
1 of 1 people found this helpful
( TimeFinished - TimeStarted ) / 3600 to get a decimal result.
By the same token, you can simplify the first calculation (complete hours worked) as
Div ( TimeFinished - TimeStarted ; 3600 )
btw: Mod (TimeFinished- TimeStarted+ 86400; 86400) is equal to TimeFinished - TimeStarted
Michele Olson wrote:
If the time will run across several days, then I would use a custom function
There's not really a need for a CF; apply the same logic using timestamps, rather than times.
Thanks so much, that's an easier way of doing it, looks like i was over thinking things. Appreciate your help