9 or 15, not 3 or 21, Mike?
--
David Biddulph

"Mike H" wrote in message
...
Hi,

You don't say which is the earlier time so the difference could be 3 hrs
or
21 hrs:)

This formula will work it out the difference with the earlier time in B2

=IF(B2D2,D2+1-B2,D2-B2)

Use a custom format of hh:mm

Mike

"tam25" wrote:

how do we calculate the amount of time between two set times? for
example,
d2 as time of 10pm and b2 has time of 7am. do we need to have the column
formatted as a time or number? Or is there a specific calc we need?

Help please