Hours between 2 dates

[Madhu Ramamurthy]

Hi,

I have a a set of two dates and times.
For Eg 01-Aug-04 13:45 and 02-Aug-04 07:00
I want the difference between these two times in terms of hours.

Thanks in advance,
Madhu

 

[Helen]

Madhu

Format the third column as hh:mm (if you also want to know
minutes) and insert the formula =b1-a1. Columns a and b
have to be formatted as dd/mm/yy hh:mm

Best Regards

 

[Madhu Ramamurthy]

Works perfect.
Thanks Helen !

Madhu

Format the third column as hh:mm (if you also want to know
minutes) and insert the formula =b1-a1. Columns a and b
have to be formatted as dd/mm/yy hh:mm

Best Regards