Hi All,
I'm Trying to compile a spread sheet to simplify tracking our employees working times. Ideally I would like to only enter the Daily Start Time for each employee, Time Taken for Break, and then the Daily Finish times and allow the work sheet calculate the Total Hours worked each day less their break time, the amount of time of time worked after (the basic 10 hours) overtime worked each day and have these calculated per employee at the end of the 7 Day week.
Currently I can get enter the start, break, and finish times and this will calculate fine, but the issue is if working less than the 10 hours I get ####. This is the same when there are no working hours entered for eg. Saturday and Sunday, all I get is #### for the overtime cell, and also it calculates 10.00 even though no start/break/finish times have been entered.
I am also looking for the total number of basic working hours worked and the number of overtime hours worked totalled in the last 2 columns.
Any help with this would be much appreciated. Sorry if I haven't explained it correctly, I have only very basic knowledge of Excel.
Bookmarks