Hi to all, I have a spreadsheet when some operator record time of entry and departure time. Example:
Entry Time (A1) DepartureTime (B1)
12:00:00 p.m. 5:30:00 p.m.
Get that differences is easy because is in the same day; I use =(B1-A1) and the result was: 5:30 hours
But my problem was when the departure time take place in the next day. Example:
Entry Time (A1) DepartureTime (B1)
9:00:00 p.m. 2:00:00 a.m.
In this case I want to get as result: 5:00 hours.
How can i do this?
Thank you so much! Hope you can help me.
Bookmarks