Format a spread sheet in minutes and seconds only

[Tucker]

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.

 

[Bernie Deitrick]

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

 

[Paul Corrado]

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.