Displaying Time in Excel

[gfkbob]

I would like to display time in minutes and seconds only even if over
an hour. If the amount of time is 65 minutes I would like it
displayed as 65:00 not 1:05:00. Is this possible in excel?

 

[JE McGimpsey]

One way:

Format/Cells/Number/Custom [m]:ss

 

[gfkbob]

One way:

Format/Cells/Number/Custom [m]:ss

I would like to display time in minutes and seconds only even if over
an hour. If the amount of time is 65 minutes I would like it
displayed as 65:00 not 1:05:00. Is this possible in excel?- Hide quoted text -

- Show quoted text -

I am using ms office 2003. I don't see the entry you are speaking
of. I see mm:ss but that doesnot work. it shows 65:00 as 5:00.

 

[JE McGimpsey]

You need to enter the string

[m]:ss

in the inputbox in the dialog.

After that, it will appear in the listbox below the input box.

One way:

Format/Cells/Number/Custom [m]:ss

I would like to display time in minutes and seconds only even if over
an hour. If the amount of time is 65 minutes I would like it
displayed as 65:00 not 1:05:00. Is this possible in excel?- Hide quoted
text -

- Show quoted text -

I am using ms office 2003. I don't see the entry you are speaking
of. I see mm:ss but that doesnot work. it shows 65:00 as 5:00.