Displaying Time in Excel

  • Thread starter Thread starter gfkbob
  • Start date Start date
G

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?
 
One way:

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

gfkbob said:
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 -
Click to expand...

- Show quoted text -
Click to expand...

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.
 
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.

gfkbob said:
One way:

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

gfkbob said:
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 -
Click to expand...

- Show quoted text -
Click to expand...

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.
Click to expand...
 
Back
Top