using logical functions

Hi,

I'm new here and not sure if this is possible.

I want to use the logical functions on timesheets to generate break times. i.e. if the shift is longer than 5 hours they get a .5hour break, and if it's less they get 0.
so I have start time and finish time in separate cells- see attached photo

but I also wanted to know if it was possible to put a logic function in with a function that calculates total hours, so that it went red if the total hours were more than 8, or less than 4?

excel example.png

The attached spreadsheet might help.

break and time logic.png


break and time logic.xlsx

Awesome, thanks humdingaling and Habanero Time


one more question though, I was hoping to have the break time dependent on a separate calculation of the start and finish time, not the total calculation, is that possible?
I've tried IF((H3-H2)*24)>5,"0.5","0"), but excel didn't like that- see below.

10-Dec 11-Dec 12-Dec 13-Dec 14-Dec 15-Dec 15-Dec
start 3:00 PM 9:00 AM 7:44 AM 10:15 AM 6:00 AM 1:00 PM 3:00 AM
finish 6:30 PM 8:00 PM 3:00 PM 2:45 PM 11:00 AM 1:25 PM 1:25 PM

TOTAL 3.5 11 7.266666667 4.5 5 0.416666667 IF((H3-H2)*24)>5,"0.5","0")
0.50 0.00 0.50 0.50 0.00 0.00

bennadelaidefringe, it would help to know more details about what you're trying to do.

One thing I see in your formula is an additional right-parentheses, and you shouldn't need those double-quotes unless you want your data treated like text.

=IF((H3-H2)*24>5,"0.5","0")

Awesome, that's solved it. Thank you very much.

Just looking to automate rosters that are used mainly for budgets.

Excellent!