If you want the result in hours (for your example the result would be 3:00)
try this
=(NETWORKDAYS(A1,B1)-1)*("17:00"-"08:00")+MOD(B1,1)-MOD(A1,1)
format result cell as [h]:mm
where A1 contains your start time/date and B1 end time/date
Note: both A1 and B1 should be within business hours
"Byron720" wrote:
Thanks. It worked. Is there a way to do the same but with hours this time?
For example: a project started at 4:00 PM and ended next day at 10:00 AM
(business hours are from 8 to 5)
"Bernard Liengme" wrote:
See Help for NETWORKDAYS
happy new year
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Byron720" wrote in message
...
How do I calculate the number of business days between two dates? For
example: between 12/01/2006 and 12/27/2006 I need a formula that
calculates
how many business days (Monday thru Friday) there are.