Hi!

If the difference is 24 hours or more, you'll have to include dates.

Examples:

A1 = 6:00 PM
B1 = 11:00 AM (next day)

Formula: format the cell as [h]:mm

=B1-A1+(B1<A1)

Returns 17:00

A1 = 2/20/2006 6:00 PM
B1 = 2/21/2006 7:00 PM

Returns 25:00

Biff

"bmg" wrote in message
...
i want to figure out the hours between two different times even if they go
into the next day ?