Hi,
I've problem to find out Time difference if second event falling on next day. Refer the enclosed sample file
Solved! Go to Solution.
Hi Pons - Thanks for quick response. if you find short work flow, please let me know
Hi @Padmanaban
See if this is a short solution for you.
IF Out Time is less than In Time, then you divide the calculation in two:
Out Time - 00:00 + 23:59 - In Time + 1.
Cheers,
Hi Thableaus - Really its very simplified and great solution! Thanks very much!