I think I'm half way to answering the 1st Q but need further help pls: If I use the following, I can work out the difference in mins between the 2 times - what it doesn't tell me is if this is early or late. Can i add colour (Red & Green) to distinguish early & late or even a minus sign??

=IF(A1B1,B1+1-A1,B1-A1)

This is now doing my head in !!!.....thx again.

--
Message posted via http://www.officekb.com