Convert minutes to hours/minutes
marmadas
-
ccm81 Posted messages 11033 Status Member -
ccm81 Posted messages 11033 Status Member -
Hello,
I would like to convert a number of minutes (for example, 510 minutes) into a format like 8h10.
I found some combinations, but when I divide 510 by 60 I get several digits after the decimal point, and my calculations don't work anymore.
How can I do this, please? :)
Configuration: Windows / Chrome 59.0.3071.109
I would like to convert a number of minutes (for example, 510 minutes) into a format like 8h10.
I found some combinations, but when I divide 510 by 60 I get several digits after the decimal point, and my calculations don't work anymore.
How can I do this, please? :)
Configuration: Windows / Chrome 59.0.3071.109
2 answers
-
Hello marmadas,
a) 510 minutes / 60 minutes = 8.5 exactly: 1 decimal only
b) 8.5 h = 8 h 30 (not 8 h 10)
c) If you have 510 in A1, put in B1: =A1/1440 =>
result if Standard format: 0.35416667
Set this result to format hh "h" mm => 08 h 30
Set this result to format hh:mm => 08:30
If instead of hh you put h: 8 h 30 and 8:30