Hello,
I am having an issue with excel. I am new with formulas so I am unable to figure this one out. I do not know much about how to create formula's. My spreadsheet TimeCard needs to calculate Regular Hours, OverTime hours and Doubletime hours worked.![]()
The issue I am having is, I have been asked to format the spreadsheet to show if an employee worked 13 hours that day, then the Regular Hours Worked (column L) should only show 8 hours, and the remaining overtime hours worked (column M) should show 4 hours, and the Doubletime hours worked (column N) should show 1 hour to equal the 13 hours. (anything over 4 hours of overtime is considered double time.)
I can only get the spreadsheet to calculate all the hours ----8 hours show in regular hours column L and the remaining 5 hours show in column M. How can I get the spreadsheet to calculate correctly to where any remaining overtime hours over 4 hours in column M automatically roll over to the doubletime column N?
Any help will be much appreciated. I also hope I explained myself correctly. Thank you for your time. I have attached a spreadsheet![]()
Bookmarks