calculating date time ranges

P

Patrick

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
 
A

anilsolipuram

Just do the difference of the dates.

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

Myrna Larson

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


=A2+B2-(A1+B1)
 
Top