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
    • 5 yrs ago
    • Reported - view

    bump

    • SMoore
    • 5 yrs ago
    • Reported - view

    up

    • SMoore
    • 5 yrs ago
    • Reported - view

    .

    • SMoore
    • 5 yrs ago
    • Reported - view

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

    • Support
    • 5 yrs ago
    • 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

Login to reply

Content aside

  • 5 yrs agoLast active
  • 5Replies
  • 1387Views