but a part is correct i found the code

=ALS($F7-$E7<TIJDWAARDE("0:30");$F7-$E7TIJDWAARDE("0:01"))

=IF($F7-$E7<TIMEVALUE("0:30");$F7-$E7TIMEVALUE("0:01"))

you wher close Luke M

thanx

"Luke M" wrote:

Try looking at Conditional Formatting (Format-Conditional Format)
I think you want a formula that looks like
=AND(B2<TIMEVALUE("0:30"),B2TIMEVALUE("0:01"))
click the format button, choose a red pattern.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"teenbeat" 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