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