Displaying Time in Excel
 

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?

Displaying Time in Excel
 

One way:

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

In article .com,
"gfkbob" wrote:

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?

Displaying Time in Excel
 

On Mar 29, 8:23 pm, JE McGimpsey wrote:
One way:

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

In article .com,



"gfkbob" wrote:
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.

Displaying Time in Excel
 

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.

In article .com,
"gfkbob" wrote:

On Mar 29, 8:23 pm, JE McGimpsey wrote:
One way:

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

In article .com,



"gfkbob" wrote:
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.