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...
It's better not to hardcode constants within the formulas, but keep them as parameters in helper ranges at any place of your workbook.
Here
it's in E1:F4
With that formula could be
=LOOKUP(A1,$E$1:$E$4,$F$1:$F$4)If you still prefer nested IF or like, you may use TIME() function not to recalculate number of minutes to numbers. E.g. 00:01:30 is returned by TIME(0,1,30)