Adding minutes and seconds

Question

How do I format cells to reflect minutes and seconds if my entry is 7.32 (7 min 32 seconds) and how do I add these entries?

Answer 1

To add to what rich007a has said, in case your number is already entered as 7.32 in A1 you may use the following formula in B1 to convert it into a time.

=TIME(0,INT(A1),MOD(A1,1)*100)

You need to change the formatting to m:ss or [m]:ss as suggested.

Answer 2

Enter your data as 0:7:32 and format the cell as Custom   m:ss

Hope that helps.

Cheers

Rich

PS. If you need to have more than 59 minutes and still have it show as minutes use [m]:ss

Answer 3

Thank you very much !!!

Answer 4

Hey, thanks for pointing out my mistake, I had interpreted the entire question as an hour and minutes question! 

I am editing out my reply above to correct the error.

Regards,

Vinay

Answer 5

Careful!

Entering  7:32 in a cell will be interpreted as 7:32 am!

I think you have to add the zero for hours so that the actual "time" you are entering is 7 minutes and 32 seconds past midnight:   0:7:32

Cheers

Rich