timesheet calculation

[Ljr0429]

I am working on a timesheet and have run into a snag, the timesheet works great when calculating 

AM to PM. But when i try to go PM to AM i get negative result any help on this issue would be greatly

appreciated......Thx Lou

[comment]

Add 24 hours to the duration when start time > end time.

[Ljr0429]

I have 4 fields StartTime, LunchOut, LunchIn, and EndTime tried adding 24 to the calculation i have

but no go

[comment]

I have 4 fields StartTime, LunchOut, LunchIn, and EndTime tried adding 24 to the calculation i have

but no go

 

Well, I said 24 hours, not 24. If your current calculation is something like =

EndTime - StartTime

change it to =

EndTime - StartTime + Case ( StartTime > EndTime ; Time ( 24 ; 0 ; 0 ) )

or, if you prefer =

EndTime - StartTime + 86400 * ( StartTime > EndTime )

[Ljr0429]

Thanks I will give this a try.....I greatly appreciate your time to answer my questions......Thx Lou