Thread: Formating Hours
View Single Post
  #2   Report Post  
RagDyeR
 
Posts: n/a
Default

Custom format your cell(s):

[h]:mm

The brackets prevent the hours from rolling over into days.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"John Knoke" wrote in message
...
I calculating "uptimes" of machines.
If I have a 100 machines that can work 24 hours it means I have
2400 machine hours of productivity.
I am not able to display 2400:00
tks for any help