Good afternoon, is it possible to create a formula that will automatically fill in in the following scenario:
My timesheet is Monday thru Sunday. I input their hours (formula calculates hours). I have to manually enter their days (total) of Per Diem, (any day worked that is more than 0 hours they get 1 full day of per diem (up to 7days)), is there a way to have that column automatically fill in according to the data in the Monday thru Friday cells for that individual? According to what cells have anything over 0 in them to calculate 1-7 in the per diem cell? I want to do this to eliminate the possibility human error of my eyes missing a day on the sheet. Thank you in advance for any assistance :-)
Bookmarks