Need help to find time difference

[Padmanaban]

Hi,

I've problem to find out Time difference if second event falling on next day.  Refer the enclosed sample file

[ponraj · Accepted solution]

Attaching a sample workflow. 

[Padmanaban]

Hi Pons - Thanks for quick response.  if you find short work flow, please let me know

[Thableaus · Accepted solution]

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,

[Padmanaban]

Hi Thableaus - Really its very simplified and great solution!  Thanks very much!