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".

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

=CEILING(A1,"00:15")

format as time


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=555039