Formating Hours
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 |
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 |
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 "RagDyeR" wrote: 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 |
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. In article , "John Knoke" wrote: 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 |
All times are GMT +1. The time now is 07:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com