Still there VoG and Larrytheone?

  Taurus 18:40 09 Apr 04
Locked

Thanks for the help with the time calculations, here's another one for you.

I have put a conditional format on cell C1 to stop it displaying when cell A1 is empty. 'If (A1=0," ",B1-C1)' I need to add a further condition to the line that will deduct 30 minutes from C1 if C1> 5 hours.

Can you help with this please?

  VoG II 18:46 09 Apr 04

Conditional Formats will only do that - format. I presume that your first conditional format sets the font colour to white or similar.

What you could do is to move the present calculation of C1 to another cell - say Z1. Then in C1 use the formula

=IF(Z1=<5/24, Z1, Z1-0.5/24)

and make sure Z1 and C1 are formatted as time.

  Taurus 18:55 09 Apr 04

Thanks a lot VoG, works a treat, exactly what I wanted.

Many thanks again

Dave

This thread is now locked and can not be replied to.

Amazon Fire HD 8 review: A brilliant combination of function and value – with one massive caveat

1995-2015: How technology has changed the world in 20 years

How to create an introvert-friendly workplace

Apple Watch 2 review | Apple Watch Series 2 review: New Apple Watch is faster, brighter, water-resit…