There's more than one way to do this depending on whether you're just
concerned about what displays or if you want to use the times and dates
generated for calculations..

For the first in both B1 & C1

=CEILING(A1,"00:15")

format B1 as date, C1 as time

OR....

In B1

=INT(CEILING(A1,"00:15"))

format as date

in C1

=MOD(CEILING(A1,"00:15"),1)

format as time

edit: or even.....

to give text results

=TEXT(CEILING(B1,"00:15"),"m/d/yyy")

and

=TEXT(CEILING(A1,"00:15"),"hh:mm AM/PM")


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