Formula IF contains certain text, then will add time to another

Closed

leoojeda Posts 7 Registration date Thursday December 21, 2017 Status Member Last seen January 4, 2018 - Dec 21, 2017 at 02:06 AM

Hello,
A1 is original time, B1 will be a type of equipment, C1 will be 40, 45 or 55 minutes, depending on types on B1, D1 will add C1 and A1 and throw a sum result of those.
I tried =IF(B1="319",+"0:40")*IF(B1="320",+"0:45")*IF(B1="321",+"0:55") And then D1=A1+C1 but all I get is zeros and no addition is made.

Formula IF contains certain text, then will add time to another
1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
How to add an accent to an e - Guide
Ms office add on pdf - Download - Other
Popcorn time - Download - Movies, series and TV
We can’t review this decision because too much time has passed since your account was disabled. ✓ - Facebook Forum

Subscribe To Our Newsletter!