converting minutes

[gregpet]

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.

 

[Brian from Maui]

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.

 

[gregpet]

Divide by 1440 is what I needed. Thanks for the quick response.

 

[Greg Truby]

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]

^edit 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. _/edit