time formats

[willie6112]

I have hours and minutes in a cell in the h:mm format. For example, 1 hour and 9 minutes appears as 1:09. I would like the cell to show total minutes, such as 69 minutes. How can I do this?

 

[sandy666]

A1: 1:09 - format: (h:mm)
B1: =A1*1440 - format: (number with no decimals), result: 69

 

[willie6112]

Thanks. That's exactly what I want.

 

[willie6112]

BTW, is it possible to present that as :69?

 

[sandy666]

you are welcome

=":"&A1*1440

 

[steve the fish]

You could format to \:[mm]

 

[willie6112]

Thanks to sandy666 and steve the fish. I think the ":" helps define the number as minutes.