I have a timecard spreadsheet in excel that automatically calculates how much
an employee worked on a day.
ex:
Clock in Lunch out Lunch in End of day TOTAL
8:30 am 12 pm 1 pm 6:00 p 8.50

I am trying to create a column in which the overtime will be carried onto
another column. So it will look something like this:

Clock in Lunch out Lunch in End of day Reg Hrs OT
8:30 am 12 pm 1 pm 6:00 p 8 .50

Is there a way in which it will done like this atumatically?