HappyChappy
Active Member
- Joined
- Jan 26, 2013
- Messages
- 378
- Office Version
- 2019
- 2010
- 2007
- Platform
- Windows
a1= 7:00 b1=00:30:00 only if d1 is populated c1 needs to show a1-b1 d1=any number
but if d1 is blank then c1 will show 7:00
i'm going round in circles missing the obvious i get error if d1 is blank
but if d1 is blank then c1 will show 7:00
i'm going round in circles missing the obvious i get error if d1 is blank