Formulae to calculate only Business hours

[Kiran Kurapati]

Hi

I am looking for formulae that needs to calculate only Business hours. I have the time in the below format


B7= 9/22/14 4:00 PM
C7= 9/24/14 8:00 PM

I want to calculate total time taken in hours

Our work starts at 2 PM every day… can someone help!!

[daddylonglegs]

Our work starts at 2 PM every day… can someone help!!

And ends when? Assuming 22:00 (10 PM) try this formula

=(NETWORKDAYS(B7,C7)-1)*("22:00"-"14:00")+MOD(C7,1)-MOD(B7,1)

format result cell as custom [h]:mm and that will give you total business hours - note you need square brackets to show time above 23:59

That works as long as B7 and C7 are within work hours, I'm assuming that Saturday and Sunday are not working days.

Change "22:00" to required work end time

[Kiran Kurapati]

Prefect!! this is fantastic... Thanks a ton