thnx for your help...i was able to fix the problem using the following
formula:

B1 = A1+TIME(0,(CEILING(MINUTE(A1),15)) - MINUTE(A1),0))
C1 = equals the same thing as B1

then i formatted B1 to be date and C1 to be time


--
kdp145
------------------------------------------------------------------------
kdp145's Profile: http://www.excelforum.com/member.php...o&userid=29594
View this thread: http://www.excelforum.com/showthread...hreadid=522319