vba excel macro change date column according to time column
===

I am facing a problem for some time now with my excel macro and i did not find a solution anywhere. What i want to do is described below :

I have an excel sheet that includes the epg information of a TV channel for the current month.
One column includes the names of the TV programs/events. Next to it another column that includes the corresponding start time of each TV program (e.g. 13:15) and a third column that  includes the corresponding date of each event (20/07/2012). 
The problem is that the day does not change after 00:00 as it should but it changes at 06:00 in the morning instead. I want a macro that searches the whole time column, find any time that is between 00:00 06:00 and go to the corresponding date cell and change the date (add one day). Is that possible and how ?

Thanks
Dion    