Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Converting Time Values

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How to convert 326.03 minutes into this form __hr__min__ sec?

    I am supposed to enter a formulae which works out the total time spent on all calls listed in a pohone bill.

    If I am provided with a data of showing all minutes and another column showing all seconds, how do I calculate the total time spent in that form __hr__min__sec?
    Pleas help.

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,075
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    Lets say that A1 houses the value "326.03 minutes".

    In B1 enter: =HOUR(A1/1440)
    In C1 enter: =MINUTE(A1/1440)
    In D1 enter: =SECOND(A1/1440)

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Australia
    Posts
    43
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ...and following on from Aladin's post, if you needed them all neatly displayed in one cell you'd put the following in cell E1 (say):

    =B1&" hr, "&C1&" min, "&D1&" sec"


    Regards,

    Penfold


  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If A1 contains 326.03 use...

    =A1/1440

    ...and format as...

    [h] "hr" m "min" s "sec"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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