converting minutes

gregpet

Board Regular
Joined
Mar 6, 2006
Messages
53
I want to display the total of a column of numbers in minutes something like this: "2:50", where the 2:50 is 170 minutes. How would I go about this? Thanks in advance.
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,458
Divide by 1440 and format the cell as time.

Or multiply by 1440 and format as a number.

Don't know if you want 2:50 to 170 or 170 to 2:50.
 

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
Hiya, Brian. Don't mean to barge in here, but thought I might add...

Greg,

If your subtotals have no dependents, then you're gonna be okay. But if you have any type of time-math downstream where this is gonna cause trouble, just do a custom format on the cell, setting the number format to [mm]

<sup>edit</sup> Uy! Never mind! That'd be relevant if you were riding the other direction. If you're dividing then you're converting decimals to time values; in which case, I don't think this is an issue. Sorry. <sub>/edit</sub>
 

Watch MrExcel Video

Forum statistics

Threads
1,108,992
Messages
5,526,109
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top