Time Calculation

[ananya11]

HI all ,

I have some data in excel like

I need Calculate working time with in (working window) Monday To Friday 9:00 to 17:30

IN Time	Out Time	Working time
12-Jan-2017 09:24 AM	12-Jan-2017 11:35 AM	2:10:54
11-Jan-2017 04:09 PM	16-Jan-2017 11:45 AM	21:05:39

<tbody>
</tbody><colgroup><col><col><col></colgroup>

 

[CalcSux78]

Excel 2010
	A	B	C
1	In Time	Out Time	Working Time
2	12-Jan-2017 09:24:00 AM	12-Jan-2017 11:35:00 AM	2:11:00
3	11-Jan-2017 04:09:00 PM	16-Jan-2017 11:45:00 AM	21:06:00
Sheet1

Cell Formulas
Range	Formula
C2	=(NETWORKDAYS(A2,B2)-1)*("17:30"-"9:00")+MOD(B2,1)-MOD(A2,1)

See Barry Houdini's blog for more info: http://barryhoudini.com/businesshours.html<!--EndFragment-->