color
 

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

color
 

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

color
 

UNFORTUNALY,

it didnt work, cause it has to be colored when the first time cel and the
second time shell time is less then 30 min that the color has to change

if its higer then 30 min then you have this formula

=$B1-$A1TIMEVALUE("0:30") then when time is more then 30 min it changes
color.
and when lower then : =$B1-$A1<TIMEVALUE("0:30")

but problem is this also changes color if start and endtime is zero (0:00).
when both times are zero then there must not be color changing

"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

color
 

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