SOLVED!
Hello All,
I have a pretty basic timesheet that I created and wondered if anyone out there can help solve my question.
What formula would be best for capping a cell of one employee's total hours worked at 40 and then putting the remaining balance in the cell next to it?
An example of what I want to do:
TimeSheet Capture.PNG
Thanks!
z0rd
Last edited by z0rd; 12-19-2013 at 10:44 AM. Reason: Solved
assuming you have monday to sunday in rows 1 to 7
you could have REGULAR HOURS as =if(sum(a1:a7)>40,40,sum(a1:a7))
then
OVERTIME HOURS as =if(sum(a1:a7)<40,0,sum(a1:a7)-40)
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
This looks like it will do the trick. Thanks! Nathansav
you will need to format the total as [hh]:mm:ss also
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks