Round Time up

  • Hello,

    I want to round up time (time after calculating differences of two times) the nearest whole value as hour(s), but if it equals or greater 30 minute(s), this should be also rounded up to nearest hour. For instance, difference between time A and time is 1 hour and 30 minutes. Then, difference should be rounded up to 2 hours, not 1 hour. Here is the formula I am dealing with:

    1. =ROUNDUP(INT((A2-B2)*24),0)

    Thanks in advance.

    [SIZE=4]"I don’t pretend we have all the answers. But the questions are certainly worth thinking about."
    Sir Arthur C. Clarke