help with formula to display 13 or 15

[LearningEX]

good morning all, this probably going to be really simple for someone, ive made a mistake in my formula and cant get it to display either a 13 or 15, if my working time is less than 13 hours worked then i need a 13 to be displayed, if greater than 13.25 (13 hours 15 min) then i need 15 to be displayed.

=IFERROR(IF(C7="","",IF(C7<13,13,IF(C7>13,15))),"")

 

[etaf]

this is similar to this question

calculating time in a 24hour period midnight to midnight

i have a day that starts at 00:00 and finishes at 00:00, i need to abstract the time before starting work and time after work. so if i start work at 6am and finish work at 21:00 (9pm). so in reality that would be 6 hours after midnight and 3 hours before midnight giving a total of 9 hours rest...

www.mrexcel.com

just different times in other post 9 & 11

you also need to use time ()
13 is not a time value

=IFERROR(IF(C7="","",IF(C7<TIME(13,0,0),TIME(13,0,0),IF(C7>TIME(13,15,0),TIME(15,0,0),C7))),"")

 

[Phuoc]

Or try:

=IFERROR(IF(C7="","",IF(C7>TIME(13,15,0),TIME(15,0,0),TIME(13,0,0))),"")