Need Help in Calculating Time: Total Time Worked *DELETED*

[noaspenwin]

Post deleted by noaspenwin

[Fitch]

Did you format your fields as time fields?

time_end - time_start = time_total

time_break_end_1 - time_break_start_1 = time_break_total_1

time_break_end_2 - time_break_start_2 = time_break_total_2

etc.

So your final time is:

time_total - time_break_total_1 - time_break_total_2 - etc.

Look at some examples at www.fmfiles.com/enduserbus5.html

[Da-Fecto]

The calculation above is nice when the job start & end is on the same day, but when the stop time is at 02.00h is and the start time was 18.00h the calculation doesn't funtion as it suposed to do.

( 86400 are the seconds in a day )

work time =

If ( (stopTime + 86400) - startTime > 86400 ; (stopTime - startTime) ; ((stopTime + 86400) - startTime ) - BreakTime )