Centi-hours
Solved/Closed
chanchan
-
leila -
leila -
Hello,
I would like to have the table that converts hours into hundredths. Can someone tell me how much 1 minute is in hundredths?
I would like to have the table that converts hours into hundredths. Can someone tell me how much 1 minute is in hundredths?
Configuration: Windows Vista Internet Explorer 7.0
15 réponses
hello
for me it's 5min=0.08
10min=0.16
15min=0.25
20min=0.33
25min=0.41
30min=0.50
35min=0.58
40min=0.66
45min=0.75
50min=0.83
55min=0.91
60min=100
for me it's 5min=0.08
10min=0.16
15min=0.25
20min=0.33
25min=0.41
30min=0.50
35min=0.58
40min=0.66
45min=0.75
50min=0.83
55min=0.91
60min=100
1/100 of an hour = 3600 seconds / 100 = 36 sec -> 0.6 minute
You must not be asking the right question.. 1/100 of an hour is 1/100 of an hour! It all depends on what you want it in.. seconds.. minutes.. because if you still want it in hours, I don't see what answer we can give you except 1/100 of an hour..
You must not be asking the right question.. 1/100 of an hour is 1/100 of an hour! It all depends on what you want it in.. seconds.. minutes.. because if you still want it in hours, I don't see what answer we can give you except 1/100 of an hour..
Hello,
The answer to your question is quite simple. It's about using a cross-multiplication:
If we start from the assumption that 30 min = 0.5 hours.
1 min = [(1*0.5)/30]
1 min = 0.016
Now you just need to apply this rule.
The answer to your question is quite simple. It's about using a cross-multiplication:
If we start from the assumption that 30 min = 0.5 hours.
1 min = [(1*0.5)/30]
1 min = 0.016
Now you just need to apply this rule.
To convert minutes into 100ths: 100 divided by 60 = 1.666666666...
15 min = 25/100ths
For example: 15 x 1.666666666 = 24.9999999999 so 25/100ths
36 min x 1.666666666 = 59.9999999999 so 60/100ths
15 min = 25/100ths
For example: 15 x 1.666666666 = 24.9999999999 so 25/100ths
36 min x 1.666666666 = 59.9999999999 so 60/100ths
Hello, to convert a time format written not in Excel format "08:12" but in the usual numerical format "8.12" for example, simply apply the following formula (where B5 is the cell containing the time value to be converted):
=IF(VALUE(RIGHT(B5,2))<1;((TRUNC(B5,0)*60)+VALUE(RIGHT(B5,1)*10))/60;IF(TRUNC(B5,0)/B5=1;B5;(TRUNC(B5,0)*60+VALUE(RIGHT(B5,2)))/60))
The value 8.12 (8h 12min) is thus converted into 8.20 (8h 20 hundredths): which allows for example to plot graphs to scale.
=IF(VALUE(RIGHT(B5,2))<1;((TRUNC(B5,0)*60)+VALUE(RIGHT(B5,1)*10))/60;IF(TRUNC(B5,0)/B5=1;B5;(TRUNC(B5,0)*60+VALUE(RIGHT(B5,2)))/60))
The value 8.12 (8h 12min) is thus converted into 8.20 (8h 20 hundredths): which allows for example to plot graphs to scale.
a bit of grammar would be just as good ;-)
19.8 mins / by 100 x by 60 = 33 hundredths
alma