+ Reply to Thread
Results 1 to 2 of 2

HELP: Time format prob in excel 2007

  1. #1
    Registered User
    Join Date
    12-19-2008
    Location
    Lisbon
    Posts
    1

    Unhappy HELP: Time format prob in excel 2007

    Trying to do a sum( of time spent at telemarketing campaigns.
    In order to calulate a true sum ,for several hundered campaigns, I'm entering
    the total time spent in h:mm:ss and multiplying for the cost(€) per hour.
    This works until the amount of time spent has 5 digits in the hours (ie, 12926:44:00).
    As soon as I have a time like that I get an #value! error in the cell where the multiplication is done.
    I have noticed that in the cells where the time has less than 5 digits in the hours,
    the format is a date/time even though that's not how I set it up or how I'm entering the data
    (ie, I enter 7715:46:00, but 11/16/1900 11:46:00 AM appears in the formula bar).
    Help. I need this for a report due ASAP and been unable to find an answer anywhere.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Welcome to the forum.

    Dates in Excel are whole numbers since 00 Jan 1900, and times are the decimal portion -- so 7715:46 is the same as 11/16/1900.

    I think you'd have a better chance of getting help if you post a workbook and explain in context.
    Entia non sunt multiplicanda sine necessitate

+ 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