Format a spread sheet in minutes and seconds only

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

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
 
P

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum hours minutes seconds excel 2003 1
Summing minutes and seconds 2
dispay numbers as minutes and seconds in excel 2
delete a spread sheet 4
sum total of hours minutes seconds in excel 2003 2
How do I change a minutes and seconds as a 2400 time to seconds? 1
how do i insert todays date in a spread sheet just prior to print 2
How do I enter accumulated time as hours, minutes and seconds? 1

Top