Formating Hours

[John Knoke]

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

 

[RagDyeR]

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!
==============================================

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

 

[John Knoke]

thanks it worked - can you explain why if I custom format the number 2400
with [h]:mm I have to divide by 24 to be able to display 2400:00

 

[JE McGimpsey]

XL stores times as fractional days. Note that display format has nothing
to do with the way the parser interprets your input (unless the format
is set to Text, which bypasses the parser). The input parsing engine
doesn't recognize an entry as a time unless a colon is included, so
entering

2400

is interpreted by XL as two thousand four hundred, regardless of display
format. The display engine will then display 2,400 days. When you divide
2400 days by 24, you get 100 days, which the display engine will show as
2400:00.