Calculate time between dates [only work hours??]
Hi guys,
I know how to calculate time between 2 dates.
But know i need to calculate 2 dates with the result that it calculates the work hours that has been passed...
I'm not sure if this is possible, i have been googling but didn't find a solution.
Hope one of you guys know a solution
Thanks in advice!
Last edited by romperstomper; 11-03-2011 at 09:12 AM.
The function NETWORKDAYS() will give you the number of "workdays" between to given dates. Use that, and multiply the days by the number of hours in your workday.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Hi JBeaucaire,
I don't really understand. Please have a look at my results
Start date: 2-01-09 12:12
End date: 2-01-09 12:47
Result Networkdays: 1
Workhours: 8,5
Result: 8,5
Am i doing something wrong?
Yeah, your sample question was unclear, your second post is clearer. You can't do calcs like that over multiple days without providing more info to the formula about what your workday hours normally are.
See the attached for a suggestion.
Last edited by JBeaucaire; 11-03-2011 at 09:27 AM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
You are the best!!! Thanks! and excuses for the confusion!
Assuming start and end times/dates are within work hours then formula should be sufficient to give you decimal work hours
=(NETWORKDAYS(A2,B2)-1)*G$2+(MOD(B2,1)-MOD(A2,1))*24
where G2 contains the daily hours
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks