Hi
Niek's suggestion works absolutely fine.
Are you sure you are putting the [ ] around the h in the custom format of
hh:mm?
It needs to be [hh]:mm not hh:mm.
The latter will only give the hours difference, as the calculation won't
roll past 24 hours.
Whether you use [h] or [hh] won't make any difference other than showing
a
leading zero for number of hours less than 10.
Regards
Roger Govier
Thanks for your reply Niek but this doesn't work or I'm doing something
wrong. If you notice the cells contain more than just hh:mm and the
dates are
not always the same.
"Niek Otten" schreef:
=B1-A1, format as [h]:mm or just[h]
(Format>Cells>Number>Custom)
--
Kind regards,
Niek Otten
I would like to calculate the elapsed time in hours of 2 cells with
the
format dd/mm/yyyy hh:mm:ss. The two cells represent the start and
finish
time
of a job and the elapsed time is 0>x<infinity. Does anybody know how
to do
this?