View Single Post
  #2   Report Post  
Niek Otten
 
Posts: n/a
Default 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?