Help with calculating time

[sdelacey]

Hi All

Is it possible for your help. I am ttrying to compose a worksheet that will calculate the difference
Between two dates and two times.

Booking Arrival Time
Date Time Date Time Diff.
5-May 12:00 4-May 10:00 26 Hours

5-May 23:00 4-May 14:00 33 Hours


To calculate the time difference, I used the formula =((24*(A6-C6)+(24*(B6-D6))))& " Hours". This works well if the times are on the hour (it will even show if it minus), however it cannot handle minutes.

Can you please show me how to amend my formula or how to do it with a macro.

Thank you

Steph

 

[TopJack]

I found this website very useful for this kind of stuff .....

http://www.cpearson.com/excel/DateTimeWS.htm#WorkHours

Hope this helps,
TopJack.