+ Reply to Thread
Results 1 to 2 of 2

Excel 2010: Formatting minutes and seconds

  1. #1
    Registered User
    Join Date
    10-14-2011
    Location
    Missouri
    MS-Off Ver
    Excel 2010
    Posts
    12

    Excel 2010: Formatting minutes and seconds

    I have a sheet where staff enter the time it takes to do a task. I'm using a custom format of [mm]:ss. However, I enter (for instance) 5 into the cell, the value becomes 7200:00. I finally figured out that this is because that is the number of minutes in 5 days. However, I don't want staff to have to enter 00:05:00 to indicate they worked for 5 minutes. I would rather them be able to enter something like 5:30 (or something along those lines) to indicate this took 5 minutes and 30 seconds. Would someone mind giving me some help? Thanks!

  2. #2
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Excel 2010: Formatting minutes and seconds

    the best I can suggest is that you could enter "0:05:30". Excel will assume the first number you enter is hours, so that is why you need to enter the "0:" first.
    Please click the * icon below if I have helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1