by Brumal » Mon Feb 29, 2016 9:52 am
I apologize for the Noobness, but I just recently started working with Excel. I am needing to know the best way to separate Regular and overtime for a 40 hour week. Employees enter in Hours and minutes manually in one range and it is currently sum'd into one cell. I am trying to get the daily hours, if over 8, to show just 8 and anything over the 8 to move into the next cell. So my end result will be Reg Hours total will always be 40, and any over 40 will be in the OT total cell. I have attached a copy of the timesheet. Again I apologize for my lack of knowledge, but I am in a time crunch, Any and all help will be greatly appreciated.
You do not have the required permissions to view the files attached to this post.