Ceiling on duration, to the nearest 15 min increment, with 1 hour minimum - help please

[Joe_Seiler]

Hello,

Can someone help me with this?

I have this formula in a google sheet, but am trying to get everything to reside in appsheet.

=CEILING(N3),“00:15”),“1:00”)

This formula looks at a cell, N3 for instance, that has a duration type, like 2:46

It them rounds the new cell up to the nearest 15 min increment, with a 1 hour minimum

So for instance,

00:02 would resolve 1:00:00
00:59 would resolve 1:00:00
01:01 would resolve 1:15:00
01:13 would resolve 1:15:00
01:15 would resolve 1:15:00 – This one is important, it can’t resolve up to 1:30:00
01:16 would resolve 1:30:00
etc.

Any idea where to start with this?

Thanks in advance