Hello,
Can someone please help me with a formula for the following.
If I have a list of values in the form (minutes:seconds)-
3:51
2:01
4:01
10:31
0:39
What formula allow me to say IF value is between 0-5:00, return '0-5:00', OR IF value is between 5:01-10:00, return 5:01-10:00, etc. I...