Hi Folks,

I have a spreadsheet that notes what date & time a boat comes in to harbour and leaves again and I'm trying to break down the time it has been sitting. At the moment the spreadsheet calculates the total hours the boat has been in but I need it to split out what would be normal time and what is overtime.

Our Normal Time hours are Monday to Friday between 8am & 5pm, anything outwith the time needs to go down as Overtime.

I've attached the spreadsheet for ease.

Can anyone help?

Regards,

Lee.

Turnaround.xlsx