If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date Difference
Hi,
I currently have following formula in my report. =DateDiff("h",[Date/Time Request Created],[Date/Time Completed]) It is calculating the total hours between time request created vs. completed. I want to be able to figure this same thing less weekends and holidays. Does anyone have any idea on how to write that formula? THANKS! -- Steve |
#2
|
|||
|
|||
Date Difference
Steve,
On my website (below) I have a sample file for V97 and V2003 called Calculate Number of Workdays. That code could easily be converted to count the number of weekend days, and holidays (from a holiday table) between your two Date/Time values. So, count the total hours between the two values, and subtract NonWorkDays * 24 -- hth Al Campagna Microsoft Access MVP 2006-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Steve" wrote in message ... Hi, I currently have following formula in my report. =DateDiff("h",[Date/Time Request Created],[Date/Time Completed]) It is calculating the total hours between time request created vs. completed. I want to be able to figure this same thing less weekends and holidays. Does anyone have any idea on how to write that formula? THANKS! -- Steve |
Thread Tools | |
Display Modes | |
|
|