I am calculating the time between an order being placed and order being delivered. I used =TEXT($R$2-$E$2,"h:mm:ss") to get this. I'm now trying to use an IF Function to say that if the time is <45 mins, say it's "fast" else, "slow". I have tried an if function text: =if((TEXT($R$2-$E$2,"h:mm:ss"))<time(0,45,00),"fast","slow") but everything returns as slow, which isn't correct. Can you help?
Solved by X. U. in 23 mins