Hi - welcome to the board.
You need to read up on how excel stores / calculates dates and times - sticking things like :30 into the formulas isn't going to help!! Check out the excel file for 'How excel stores dates and times', then see here:
for more info (click on the introduction link & find the dates / times page). Then see here:
for all sorts of info.
That said, try:
EDIT - correcting the < and > in the formula...
[ This Message was edited by: PaddyD on 2002-09-26 20:43 ]