-1

Is there a way to format the following number (in minutes) to human readable text:

60 > 01:00:00
60.5 > 01:00:30
24 > 00:24:00
1.5 > 00:01:30
80 > 01:20:00
120 > 02:00:00
0

1 Answer 1

2

Suppose your posted raw data were in A2:A. In B2 of an otherwise empty range B2:B, place the following formula:

=ArrayFormula(IF(A2:A="",,A2:A/24/60))

Then select Col B entirely and apply the following format:

Format > Number > Custom number format > hh:mm:ss

/24/60 divides your raw numbers by 24 hours per day and then 60 minutes per hour. You could just use A2:A/1440, but I find that seeing /24/60 makes more sense to most people.

Not the answer you're looking for? Browse other questions tagged or ask your own question.