Forum Discussion
IF, THEN for time range formula assistance
Hello, I scoured the forums for a scenario like mine so I didnt post something redundant, but found nothing. please let me know if anyone can help with this: goal is to "score" call center st...
Excel expresses time as a decimal value where 1 day = 1, so 1 minute would be 1/1440 or 0.00069444. You can see this if you select cell C66, select format cell and switch it to general (switch back afterwards because it isn't very readable that way).
For your formula try using =IF(C66>1/1440, "STRETCH") instead, this would be 1 minute. If you want to do this by seconds, try =IF(C66>59/8640, "STRETCH") for 59 seconds.