Overtime work based on Duration after 05 PM and Before am

Nope, that calculation should be 2 hours because it is still in the period form 17:00 to 06:00.

Aaaarrhgghhhh…My eyessss killing me :see_no_evil: From your post I have read the [Time Out] as 08:01:32 AM and [Time In] as 08:03:32 AM :rofl: :rofl: :rofl: :rofl:

@Louwrens
I have slightly edited my expression in post#40 above. Can you please try with that and feedback me? Thnx.

1 Like

Thanks will run a few test and revert :muscle:t3:

Thanks for the effort over the last 2 weeks.

The formulation / Expression is 100 %.

1 Like

You’re welcome @Louwrens and thanks for the feedback. I’m glad to hear that it’s working 100% now.