Results 1 to 2 of 2

Thread: Please HELP me with this...

  1. #1

    Exclamation Please HELP me with this...



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

    I want to round the time like this

    HH:MM
    IF 00:05=00:15
    00:10=00:30
    00:45=01:00

    or
    HH:MM
    IF 01:05=00:15
    01:10=00:30
    01:45=02:00

    But if the condition does not meet, it will automatically round down descending

    ex:1
    If 01:04 then it should be

    01:04=01:00

    ex:2
    If 01:44 then it should be

    01:44=01:30




    PLEASE PLEASE!!!

    I realy need it ryt away!

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,829
    Articles
    0
    Excel Version
    O365
    You need to explain that. Why does the first go to the next quarter hour up, but the second goes to the next half hour up?

Posting Permissions

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