Teenbeat, i'm confused your end time is before your start time? can you
explain what you are trying to achieve?

teenbeat;268589 Wrote:
the thing is and that is my question when i have a starting time lets
say in
cel B1 and a end time in cel A1. A1 is 0:00 and B1 is 0:30
when time in B1 gets lower then 0:30 but higher then 0:01 it has to get
color red
but when they are both 0:00 nothing has to change accept standard cel
colors
Also i have a already placed time value formula in it :
=$D6-$F6TIMEVALUE("0:30")
can anyone help me
if nessecary i can send a exsample file


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=74947