daddylonglegs wrote:
Franz Verga Wrote:
try with this new formula:

=IF((A45+0.5/60/24)-(ROUND(A45/(15/60/24),1/60/24)*15/60/24)0,(ROUND(A45/(15/60/24),1/60/24)*15/60/24)+15/60/24,(ROUND(A45/(15/60/24),1/60/24)*15/60/24))


As somebody said of one of my recent postings here, "this is like
using a sledgehammer to kill an ant".

Yes, you're right, but for me this is the first time "playing" with time...

To round up a time in A1 to the next 15 minute increment

=CEILING(A1,"00:15")

format as time

But in this way yo rouund 13:15 to 13:15, while the OP requested to round
13:15 to 13:30 and so on, so I think the smaller formula should be:

=CEILING(A1+"0.01","0.15")

--
Ciao

Franz Verga from Italy