Calculating elapsed time
=B1-A1, format as [h]:mm or just[h]
(FormatCellsNumberCustom)
--
Kind regards,
Niek Otten
"andoh" wrote in message
...
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 0x<infinity. Does anybody know how to do
this?
|