Hi,
Being a novice in excel I in need of your help .
I ve an excel "Time sheet creator "(attached) which extracts the data from a in-out time excel file(not attached) and it outputs a separate excel file like I attached "Timesheet_10_15_2015.xlx".
Now my problem is I need add a checkbox in "Time sheet creator" if it is checked, then it will output total working hours per day to 9 hours if it the total time per day is <9 hours or >13 hours. Now I am doing this manually if the working hours is <9 hours or >13 hours. And I ve tried something in L351 but seems some error. Any suggestion would be very helpful and save my lot of time in daily basis.
Best Rgds
PD
Bookmarks