I have a spread sheet where extra time worked in entered in to two columns, start extra time and finish extra time (column A 17:30 Column B 18:15). This then is totaled in a running total in hours and minutes in another cell. On the same spreadsheet, the employee enters time in two columns when finishing early and time rostered to finish when leaving early to use the time owed. This is then calculated as another column as a running total. I need the running total of time taken subtracted from the running total of time accrued. I cannot figure out how to do this.
I have attached the work book
any and all help will be greatly appreciated
Bookmarks