Number of hours between two separate dates

[qulex]

Hello,

I am trying to figure out a way for Excel to return a number of hours between to separate dates.

Date Start Time End Time Time to recovery Time btw Failures (hrs)
8/28/2011 9:16 AM 10:00 AM 0:44:00 0:00:00
8/28/2011 10:19 AM 10:59 AM 0:40:00 0:19:00
8/28/2011 11:16 AM 2:59 PM 3:43:00 0:17:00
8/28/2011 4:05 PM 6:00 PM 1:55:00 1:06:00
8/29/2011 7:39 AM 6:00 PM 10:21:00 ###
8/30/2011 7:37 AM 4:59 PM 9:22:00 ###
8/30/2011 5:01 PM 6:59 PM 1:58:00 0:02:00
8/31/2011 8:13 AM 7:44 AM ### ###


When the date changes, the spreadsheet can't calculate the number of working hours between the two times (from 8/28/2011 6:00 PM to 8/29/2011 7:39 for example).

Any help would be greatly appreciated!

 

[number kruncher]

If the data you have provided are in seperate columns, from A to D, then you could use..

=(A3+B3)-(A2+C2)

=(currentline date+start time)-(previous date+end time)

HTH