Calculating hour outside core hours when all hours fall outside core
I am trying to set up a time sheet for staff where it calculates hours worked in and outside of core hours. I can do a calculation to work out what they have worked in and out of core hours providing that part of their time starts of finishes in core times. The problem I am having is when some one works only outside core hours. Our core hours are 6am to 6pm. The problem is when they work from say 7pm to 1am. This is irregular work paid as overtime not shift work.
Thanks for any help
Last edited by JBeaucaire; 04-22-2014 at 02:12 AM.
Can you attach a sample sheet showing the problem?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Time sheett.xlsx
Here is the one I have. As you can see the second entry will not work.
Thanks
OK. To me, this bit of your formula seems problematic:
D14-IF(C14<G$9,G$9,C14)
C14 is 0:00. G9 is 06:00. D14 is 05:00.
D14-G9 gives a negative number.
Which are you referring to as the second entry?
Yes this seems to create the problem. Is there another formula I can use?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks