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

Thread: Time Formula .... HELP!!!

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

    Default

    I'm struggling here and could REALLY use some help. I'm trying to come up with a formula to convert a number, say 2000 (minutes) to a Time format. The data I receive is not in a time format. The problem is that when I come up with a formula, I can convert without any problems, but only up to 24 hours. After that, it kicks back down and starts back at 0:00 instead of moving up to 25 hours. For example, 2000 minutes is actually 33:24, but will only show up as 9:24 since it won't count higher than 24. Anyone have any suggestions out there???

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-27 06:31, iibobii wrote:
    I'm struggling here and could REALLY use some help. I'm trying to come up with a formula to convert a number, say 2000 (minutes) to a Time format. The data I receive is not in a time format. The problem is that when I come up with a formula, I can convert without any problems, but only up to 24 hours. After that, it kicks back down and starts back at 0:00 instead of moving up to 25 hours. For example, 2000 minutes is actually 33:24, but will only show up as 9:24 since it won't count higher than 24. Anyone have any suggestions out there???

    =A1/1440

    with a format of [h]:mm should do the trick

    result is 33:20 though.


    good luck

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    IML, It works!! Thank you so much! I truly do appreciate it.

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
  •