G
Guest
I'm in the process of making a timesheet.
in column A1 will be the start time (00:00); in B1 will be the finish time
(00:00). I want to calculate the hours between these two times (hrs) but not
allow the figure in C1 to go above 8hrs. Any additional hours (over 8) will
be moved to D1.
Example: A1 (08:00) B1 (20:00) C1 (8hrs) D1 (4hrs)
Column A = start work
Column B = finish work
Column C = hours at normal rate (up to 8 hours)
Column D = hours at 1/2 time rate (number of hours over 8)
Any help you could give would be much appreciated
in column A1 will be the start time (00:00); in B1 will be the finish time
(00:00). I want to calculate the hours between these two times (hrs) but not
allow the figure in C1 to go above 8hrs. Any additional hours (over 8) will
be moved to D1.
Example: A1 (08:00) B1 (20:00) C1 (8hrs) D1 (4hrs)
Column A = start work
Column B = finish work
Column C = hours at normal rate (up to 8 hours)
Column D = hours at 1/2 time rate (number of hours over 8)
Any help you could give would be much appreciated