working with hh:mm:ss formats and IF statements

[anotherrachel]

Hello
I am trying to write an IF statement using date/time/hh:mm:ss data and would appreciate some help.

I have ~ 150,000 rows of data so am keen not to review line by line.​

I have an extract of data with a date time stamp and I have calculated the difference between two times.
eg:
I have subtracted the first time stamp 29/10/2019 7:14:57 AM from the second time stamp 2

9/10/2019 7:20:00 AM.
The answer with the format h:mm:ss is 0:05:03 (eg in cell c10)​

In another cell, I would like to have an IF statement to group the time into 3 buckets
anything > 20 minutes = "long break", anything < 5 minutes = "working", all other = short break

=IF(c10<5,"working",IF(c10>20,"long break","short break"))
In the example above, I would expect the result would be "short break" but it does not seem to work.
I assume because the numbers 20 and 5 are incompatible with the 5:03 minutes above.

Does anyone how I can make the IF statement work?

Thank you!

 

[MARK858]

Maybe (untested)…

=IF(C10<TIMEVALUE("00:05:00"),"working",IF(C10>TIMEVALUE("00:20:00"),"long break","short break"))

 

[anotherrachel]

Thank you - yes it does work!
Much appreciated as I spent an hour pulling out my hair before I posted!

 

[MARK858]

No problem and welcome to the board