I have a timesheet I am trying to create.

Format, Custom HH:MM

Cell A1 8:30 am (start time)
Cell B1 6:30 pm (end time)
Cell D1 12:00 pm (lunch start)
Cell E1 1:00pm (lunch end)

I want F1 to show regular time up to 8 hours (no more)
I want G1 to show overtime, over 8 hours. (no limit)

F1 should read 8 hours and G1 should read 1 hour if this works as I want.

Anyone know of a creative way to do this?

Thanks!