I've tweaked them a little, you can check if they work now:
Column B: =IF(C10=0,INT(A10)+1,INT(A10))
Column C: =TIME(HOUR(A10),INT((MINUTE(A10)-1)/15+1)*15,0)
---

"kdp145" wrote:


i tried the formula you suggested, but they dont work....the date doesnt
change to the next day when anything greater than 11:46PM is incremented
to 12:00AM. the time doesnt work in some cases. for ex: if time is
11:23PM, it will increment it to 11:30PM, which is fine but if the time
is 11:30PM, it increments to 11:45PM instead of staying at 11:30PM.

anybody have any other suggestions?


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