Need formula

[JEC8878]

Could someone please help. I am looking for a formula that will help calculate some timings –

Please see attached document – what I am wanting is –

If planned duration is 45m to highlight any actual times that are at least 15m under this (so 30m or below)

 

[ETAF]

try
=AND($D2<>"",$D2<=30)

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
D2:D100 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=AND($D2<>"",$D2<=30)

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

 

[JEC8878]

Thats great thank you so much

 

[ETAF]

you are welcome