Date and Time Calculations

[Guest]

How can I calculate the difference between a date and time format and another
date and time format? I would like the return value be in hours.

Ex: 10/27/2006 10:00 - 10/26/2006 12:00 = 22 hours

 

[Dave Peterson]

Subtract the smaller from the larger and use a custom format of:

[hh]
or
[hh]:mm

The [] means that the hours won't roll into days.

 

[David Biddulph]

=A1-A2 and format as [h]:mm

 

[Guest]

Thank you very much.....I learn something new with the brackets [hh].

Wayne

Subtract the smaller from the larger and use a custom format of:

[hh]
or
[hh]:mm

The [] means that the hours won't roll into days.

How can I calculate the difference between a date and time format and another
date and time format? I would like the return value be in hours.

Ex: 10/27/2006 10:00 - 10/26/2006 12:00 = 22 hours