Working days calculation with Time stamp

HI All,

I need assistance on calculating working days between two dates with time excluding saturday, sunday, India & US holidays.

Working hours - 8
Start date - 5/23/2015
End date - 5/24/2015
Result -

Holidays
5/23/2015
5/24/2015
5/25/2015
6/6/2015

We have scenarios like Start date & End date are dynamic which also contains holidays where working days should be accurate.

Any help here would be great!!!!

Thanks in advance for assistance..

=NETWORKDAYS.INTL(A1,A2,1)


Regards
Shareez

Hi,

See the attached file.

Please Login or Register  to view this content.

This will give you the working days between two dates excluding weekends and list of holidays. This cannot be used to calculate the time difference (TAT).

Hi,

I have used this formula =NETWORKDAYS.INTL(A6,B6,1,$E$2:$E$6). But i need time in with output.
For eg
Start Date - 5/23/2015 10:10

End date - 5/28/2015 12:00

Result should be 2.5

Holidays
5/23/2015
5/24/2015
5/25/2015
6/6/2015

Kindly assist on with suitable function.

Hi,

But i'm getting negative value between dates 23/May/2015 10:10 & 28/May/2015 12:00.
How to make negative output to zero by including in the same formula.

Thanks.

sorry date is between 12/21/2014 18:05 12/22/2014 0:25

Hi,

See the updated file attached!

Please Login or Register  to view this content.

Maybe:

=NETWORKDAYS(A2,B2,$I$2:$I$5)+NETWORKDAYS(B2,B2,$I$2:$I$5)*(MOD(B2,1)-1)-NETWORKDAYS(A2,A2,$I$2:$I$5)*MOD(A2,1)

and formatted as decimals 2 digit

can you please help me to calculate working days and hours excluding weekends. here with attached the file.

Hi thisara , you should start on your own thread

thank you

Thank you azumi. I have started a new thread.
http://www.excelforum.com/excel-form...date-time.html

Originally Posted by azumi

Hi thisara , you should start on your own thread

thank you

@karthik premkumar,

Use azumi's formula from post#9, this seems to work perfectly!

=NETWORKDAYS(A2,B2,$I$2:$I$5)+NETWORKDAYS(B2,B2,$I$2:$I$5)*(MOD(B2,1)-1)-NETWORKDAYS(A2,A2,$I$2:$I$5)*MOD(A2,1)