0

Round up or down

I am trying to create a formula (time) that will round up to the nearest 15 minutes, so 9999002000000 for on the hour, 9999002900000 for quarter after, 9999003800000 for 00:30, and 9999004700000 for quarter till. 

 

I want a button that when I click it, it will increase the data/time record 1 hour from now, but round up to the nearest 15 minutes. I just need assistance with the rounding portion of it. 

5 replies

null
    • SMoore
    • 6 yrs agoWed, January 2, 2019 at 1:34 AM UTC
    • Reported - view

    bump

    • SMoore
    • 6 yrs agoFri, January 4, 2019 at 3:38 AM UTC
    • Reported - view

    up

    • SMoore
    • 6 yrs agoMon, January 7, 2019 at 9:56 PM UTC
    • Reported - view

    .

    • SMoore
    • 6 yrs agoWed, January 9, 2019 at 8:47 PM UTC
    • Reported - view

    This keeps getting buried. Is anyone able to assst me with this thread?

    • Support
    • 6 yrs agoFri, January 11, 2019 at 5:04 PM UTC
    • Reported - view

    Hi, 

    I think this would be a good question to raise in our webinar on tuesdays at 18 o'clock CET.

    You can register for it here: https://zoom.us/webinar/register/WN_zoSk2qyNSz6vLRFF1zlakg

    Best, Jörg