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.
 
You must log in or register to reply here.

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
Daily Time Sheets with Rounding 1
delete a spread sheet 4
dispay numbers as minutes and seconds in excel 2
SAVED CHANGES CAN NOT FIND SHEET WHERE WOULD IT BE 1
how do i insert todays date in a spread sheet just prior to print 2
Convert text entered as minutes/seconds to minutes 1
Cleaning up spread sheets 1

Back
Top