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
Solved! Go to 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
Magic!! Cheers @BenMoss