Still there VoG and Larrytheone?

  Taurus 18:40 09 Apr 2004
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 2004

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 2004

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.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

Add Depth Of Field to a photo using Tilt Shift Blur in Photoshop

iPhone tips & tricks

Les meilleures tablettes 2017