Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate hours just can't figure it out | Excel Worksheet Functions | |||
calculate difference in time to hours | Excel Worksheet Functions | |||
need help w/formula for calculating overtime hours | Excel Worksheet Functions | |||
Subtracting paid hours from unpaid hours | Excel Worksheet Functions | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions |