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

Wayne

"Dave Peterson" wrote:

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.

wayne wrote:

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