Duration Accross 2 day

[JTCairns]

Hi All

My brain wont work today, im calcuating duration of certain shifts but i cant remeber how to take into account shifts over 2 days. e.g

Arrive           Leave
21:00:00      07:00:00

This should be 10 not 14. Anyone got a work around

Cheers

[BenMoss · Accepted solution]

Create two calculated fields.

ArriveNew

"2018-01-01 "+[Arrive]

LeaveNew

if [Leave] > [Arrive] 

then "2018-01-01 "+[Leave]

else "2018-01-02 "+[Arrive]

endif

Then do your datediff on these new fields.

Ben

[JTCairns]

Magic!! Cheers @BenMoss