Hello from Steved A1 is 39:20 B1 is 40:00 in C1 how do I put an if statement in this case C1=00:00
S Steved Apr 15, 2004 #1 Hello from Steved A1 is 39:20 B1 is 40:00 in C1 how do I put an if statement in this case C1=00:00
V Vasant Nanavati Apr 15, 2004 #2 Your question is very confusing, but if I understand it correctly: =(A1>B1)*(A1-B1) with C1 formatted the same as A1 and B1 ([h]:mm).
Your question is very confusing, but if I understand it correctly: =(A1>B1)*(A1-B1) with C1 formatted the same as A1 and B1 ([h]:mm).
S Steved Apr 15, 2004 #3 Thankyou -----Original Message----- Your question is very confusing, but if I understand it correctly: =(A1>B1)*(A1-B1) with C1 formatted the same as A1 and B1 ([h]:mm). -- Vasant Hello from Steved A1 is 39:20 B1 is 40:00 in C1 how do I put an if statement in this case C1=00:00 Click to expand... . Click to expand...
Thankyou -----Original Message----- Your question is very confusing, but if I understand it correctly: =(A1>B1)*(A1-B1) with C1 formatted the same as A1 and B1 ([h]:mm). -- Vasant Hello from Steved A1 is 39:20 B1 is 40:00 in C1 how do I put an if statement in this case C1=00:00 Click to expand... . Click to expand...
