Just need to subtract:

=A2-A1

Format as [h]:mm

--
Biff
Microsoft Excel MVP


"Jack Black" wrote in message
...
I would like to put a date and time in A1 and a later date and time in
A2 and have B2 to show the difference between these 2 times in hours
to 2 digits .

Does anyone know how this can be done?


Thanks