Hi,
I found the following calculation which resolves number of business days between Mon and Friday only (excludes weekends):-
(DATEDIFF('day',[StartDate],[EndDate]) -
(7-DATEPART('weekday',[StartDate])) -
DATEPART('weekday',[EndDate])
) / 7*5
+ MIN(5,(7-(DATEPART('weekday',[StartDate]))))
+ MIN(5,(DATEPART('weekday',[EndDate])-1))
I need to convert this to "hours". I have tried changing the "datediff" part from 'day' to 'hour', but cannot get it to calculate work quite right.
I've played about with this by changing 7 to 24 etc, but the calculation is slightly out.
Many thanks in advance.
Hi, Paolo
This is much easy to fix, in my calculation field, change everything from 'hour' to 'minute' and create the calculation like
Floor([Copy Hours]/60)
Below is the result
workbook updated and attached.
Hope this could solve your problem.
ZZ
