Format a spread sheet in minutes and seconds only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to make a spread sheet that will work in minutes and seconds in excel.
It is for figuring up-time and down-time for a production line. I do not
want the minutes changed into hours.
 
Tucker,

Enter your time values with leading 0's

0:22:13

or enter your times in hours and minutes (without the leading 0), and divide
by 60 somewhere else to compensate.

HTH,
Bernie
MS Excel MVP
 
Time is stored in XL as the decimal portion of a day. 3:00 AM has a value
of 0.125 (which is the time divided by 24 or 3/24)

The time value that is displayed is based on the cell format.

To show elapsed time in minutes use

[m]:ss

as the Custom Format.
 
Back
Top