Converting hh:mm:ss to mm:ss

[sled98]

Hi.

I've got a spreadsheet where I'm adding up times which are in the mm:ss.0 format. Sometimes they add up to > 60 minutes, but I want them displayed in total minutes rather then hours and minutes. For example, instead of 1:07:35.4 I want it to show 67:35.4. Currently, if I change the cell format to mm:ss.0, it only displays 07:35.4 (ie it drops the 60 minutes that make up the hour).

Is there a way of displaying it in total minutes irrespective of whether it's above or below 60? So 1:07:35.4 is 67:35.4 and 57:22.6 is still displayed as is.


Thanks.

 

[Jonmo1]

Welcome to the board.

Try a custom format
[mm]:ss.0

 

[sled98]

Perfect - thanks.

I LOVE this Mr Excel Forum!