Rota deducting lunch if shift over so many hours

BDMcQ

New Member
Joined
Jul 11, 2018
Messages
1
So I want to get a total amount of hours worked in a day, which takes away lunch of 30 mins if someone works 6 or more hours, what formula do I use? Cheers
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Watch MrExcel Video

Forum statistics

Threads
1,099,684
Messages
5,470,113
Members
406,681
Latest member
sachinmasurkar

This Week's Hot Topics

Top