Help with time difference between 2 dates

[samatdell]

Hi,

I work at a call center and I get the data as Date, Time of calling and Duration of the call. Now since this is an overseas call center, even though the calls spills over 12midnight, the corresponding date shows as the date when the agent logged in.
So I get the data in this format, Date: 06/11/2012, Time: 19:00:00 - 04:00:00. How do I calculate the time difference at one go without first getting the time difference from the time of login till midnight and then add that to the time difference of midnight till time of logout. I have attached a file for your review.

Regards,
Simon.

[TMS]

I'm not entirely sure what you are trying to do and the sample file doesn't actually clarify that for me.

However, if you have a date and time in one pair of cells and a second date and time in another pair of cells, just add each pair together and subtract the result.


Regards, TMS