calculating date time ranges
 

I have a spreadsheet that I wish to calculate the number of hours between two
events. The first event has a date column and a time column (i.e. 11/9/04
0700) the second event also has a date column and a time column. I would like
to calculate the number of hours difference between the two events. Example
first event 11/01/04 0700 and second event 11/05/04 1100.
Thanks for any help

Just do the difference of the dates.

But make sure the resulting cell has the custom format "[hh]:mm"


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=277245

Assuming earlier date in A1, time in B1, 2nd (later) date in A2, 2nd time in
B2


=A2+B2-(A1+B1)


On Wed, 10 Nov 2004 16:21:04 -0800, "Patrick"
wrote:

I have a spreadsheet that I wish to calculate the number of hours between two
events. The first event has a date column and a time column (i.e. 11/9/04
0700) the second event also has a date column and a time column. I would like
to calculate the number of hours difference between the two events. Example
first event 11/01/04 0700 and second event 11/05/04 1100.
Thanks for any help