Try the attached.

The only problem with it, is if you select a date, which is not a
Monday, then select a time, then go back and change your date to a
Monday, the time will be left in place from the original entry, however
if you put in Conditional format to make it white on white when this
happens, this may solve this problem (if you feel this is sifficient).

The formula in C52 and D52, could be simplified to just typing the
values into the cells, rather than the formula, but at least this way
it allows you to insert/delete rows, without having to update the
formula.

Good Luck

G


+-------------------------------------------------------------------+
|Filename: test report.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4576 |
+-------------------------------------------------------------------+

--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=528681