07-02-2009, 03:12 AM
|
|
Registered User
|
|
Join Date: 02 Jul 2009
Location: denmark
MS Office Version:Excel 2003
Posts: 1
|
|
Help with calc time in certain periods
Please Register to Remove these Ads
Hi, my first post here - hope you guys can help me as I'm really lost here.
I need to make a excel sheet where I can keep track of a how many hours(or mins) a person is at work during a 24h day/week, with different saleries depending on different times of the day and if it's weekend or not.
The tricky part for me, is that I need to keep track of how many hours a person is working between 06:00-17:59 and how many are not (ie. between 18:00-05:59).
Also, I need to keep in take into account if it's between 06:00 saturday morning to 05:59 monday morning, then it needs to be calculated seperately as well. If this can be solved with a dropdown to indicate if it's weekend or not, that's fine with me
I've tried to do this with a =IF(AND statement, but I'm not a programmer and I'm completly at a loss here
So far what I came up with is a statement that checks if the meeting time is between 06:00 and 17:59 - but it's like I need a whole different level to take everything into account.
=IF(AND(B5>=0,25;B5<0,75);(C5-B5)+(("23:59"-D5)+"00:01")+((E5-"00:01")+"00:01");0)
(The 0,25 I found equals 06:00 and 0,75 equals 18:00)
Are there any who can help me?
Best regards,
Casper
Last edited by casper v; 07-02-2009 at 03:15 AM.
|
Linear Mode
