Results 1 to 4 of 4

Thread: Converting a number into time

  1. #1

    Converting a number into time



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am currently working with a spread sheet that his hours and seconds listed as a long number as shown below.

    166428

    What I am trying to do is to get that number to look like this: (39 hours : 56 Minutes)

    39:56

    The closest I have come is by using the formula [=(A1/60)/60] which produces 39.94. I am having the most trouble trying to get that converted into a time format HH:MM. Seconds are not needed as they are included in the minutes.

    I've tried formatting but it just gives me a 0:00:00 response each time. Any kind of formulas or formats that I can use to get it to look like that?

    Edit:
    This is a duplicate...can be deleted. Sorry for the double post.

  2. #2
    Use

    =A1/24/60/60

    and format the cell as [h]:mm

  3. #3
    I don't think that's a standard date/time number, therefore normal formatting won't work.
    And I also think you may have posted the wrong number...maybe 143784?

    Anyway, if that is right you could try this.
    =INT(A1/60/60)&" Hours : "&INT(MOD(A1/60/60,1)*60)&" Minutes"

  4. #4
    Quote Originally Posted by Bob Phillips View Post
    Use

    =A1/24/60/60

    and format the cell as [h]:mm
    Worked perfectly! Thanks!

Posting Permissions

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