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

Well, thanks for pointing out the obvious, lol
Sorry, about that, and thanks for your teaching method.
Here’s the final, adding the 1 hour minimum as well.

IF([T&M: Total Time Hr, Min]>=“001:00:00”, (TIME(CONCATENATE(“0:”,(CEILING(TOTALSECONDS([T&M: Total Time Hr, Min]-HOUR([T&M: Total Time Hr, Min]))/60.0/15.0)*15),“:0”))-“00:00:00”+HOUR([T&M: Total Time Hr, Min])), 001:00:00)

3 Likes