Hours between 2 dates

  • Thread starter Thread starter Madhu Ramamurthy
  • Start date Start date
M

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
 
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
 
Works perfect.
Thanks Helen !


Helen said:
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
Click to expand...
 
Back
Top