Ask Experts Questions for FREE Help !
Ask
    ecarranco's Avatar
    ecarranco Posts: 2, Reputation: 1
    New Member
     
    #1

    Nov 9, 2009, 04:34 PM
    How do I convert seconds to true time
    I have a bunch of values that are in seconds 1815632 seconds. Dividing that by 60 and the results of that by 60 I get 504.34 hours. This is close, but I don't want decimal. I need it to tell me it is 504 hrs and XX Minutes and xx seconds. This is the requirement now, but I'm sure it will change to take the seconds and convert it to days/hours/minutes/seconds eventually.

    Thanks you in advance for your assistance.
    Synnen's Avatar
    Synnen Posts: 7,927, Reputation: 2443
    Expert
     
    #2

    Nov 9, 2009, 05:09 PM

    Multiply the decimal (.34) by 60 to get the number of minutes, then the decimal of THAT again by 60 to get the number of seconds.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #3

    Nov 9, 2009, 06:06 PM

    In an adjacent cell, enter this formula:

    =A1/86400

    Then apply a custom number format to it like so:

    [h]:mm:ss


    Result: 504:20:32

    Or to get it spelled out, a custom number format of:

    [h] "hours" mm "minutes" ss "seconds"

    Result: 504 hours 20 minutes 32 seconds


    ========
    To include days:

    d:h:mm:ss

    Result: 21:00:20:32

    d "days" h "hours" mm "minutes" ss "seconds"

    Result: 21 days 0 hours 20 minutes 32 seconds
    ecarranco's Avatar
    ecarranco Posts: 2, Reputation: 1
    New Member
     
    #4

    Nov 9, 2009, 06:12 PM
    You folks are awesome! Thanks so very much.

    Solution was.

    =TEXT(A1/86400,CHOOSE(MATCH(A1,{0,60,3600},1),"s ""sec""","m ""min"" s ""sec""","[h] ""hrs"" m ""min"" s ""sec"""))

    Your prompt reply is sooo very much appreciated!

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Heater only runs for 20 seconds at a time. [ 13 Answers ]

Hello, I have a gas heater in my trailer, not quite 20 years old. It heats up very well, but the fan will only stay on for 20 seconds at a time, tops. It seems to be keeping the trailer warm enough, but I suspect it is causing efficiency problems. We have even had someone cone in to look at...

True or Not True about Breast Cancer and plastic bottle water in left a car [ 8 Answers ]

I had this conversation with one of my co-works today regarding Breast Cancer. She told me that you women can get breast cancer by bottle water left in a car. I don't believe it. Is there anyone who can answer this question please?

L1 to H4 Status- procedure and time to convert [ 1 Answers ]

Hi, I am currently on L1 visa here working for a company. However, I have also got a H4 visa. The I94 on my passport is currently for L1. Due to some personal reasons, I have to quit my job now and change the status to H4. How long would this process take, what all forms should I fill and where...

Outside Blower kicks on for 5 seconds then goes off for 10 seconds [ 1 Answers ]

I've looked all over this forum for something like this, but nothing I've see quite nails my problem so If I missed it, sorry. Here it goes... My outside blower comes on for about 5 seconds when my thermostat activates for the heat. With furnace still on the blower shuts off for 10 seconds and...

Vision loss in left eye only for seconds at a time [ 11 Answers ]

I am a 28 year old woman who has been having vision loss in my left eye for the last 6 months. It happens anywhere from 5-20 or more times a day. The loss of vision is for less than 1o seconds but it is very strange. It usually happens when I stretch or do a sudden balance change. I do not get...


View more questions Search