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 answers
-
It's a converter from hours and minutes to hundredths. Unfortunately, it doesn't do the reverse, but it is perfect in this direction.
http://www.casamape.fr/guide-employeur/calculatrices/conversion-minutes-centiemes.html -
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 -
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..
-
Good evening,
I think that's what he wants:
1 min = 1h/60 = 1/60 = 0.016666666 h
eric -
-
-
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. -
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 -
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 I work 5 hours and 15 minutes, that amounts to 5 hours and 25 minutes (at 70 euros per hour).
Can someone tell me how to find the price? -
-
-
Good evening
Just in case:
One hour = 100
One hour = 60 min
One minute therefore equals 100/60 or 1.6666666666666667 hundredths of an hour.
Best regards
--
The truth is not possessed, it is only sought. -
1 minute in hundredths of an hour is .0166666.....
ex.: 7h01 = 7.0166666 in hundredths of an hour
the method is to multiply by 100 and divide by 60 (ex. 7h25 min. = .25 x 100 / 60 = .42)