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 From your post I have read the [Time Out] as 08:01:32 AM and [Time In] as 08:03:32 AM
@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
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.
@LeventK Great work on logic and expression. just curious this will not take into consideration of non-working day (or PH) right? was thinking WORKDAY() but however it doesn’t do duration. WORKDAY() just a DATETIME which give you the next WORKDAY based on the input.
Do you think it is possible to calculate duration to exclude non-working day. (SAT and SUN) which i think you have asked before. which i think that’s should be challenging right.