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

[TABLE="width: 371"]
<tbody>[TR]
[TD]IN Time[/TD]
[TD]Out Time[/TD]
[TD]
Working time
[/TD]
[/TR]
[TR]
[TD]12-Jan-2017 09:24 AM[/TD]
[TD]12-Jan-2017 11:35 AM[/TD]
[TD]2:10:54
[/TD]
[/TR]
[TR]
[TD]11-Jan-2017 04:09 PM[/TD]
[TD]16-Jan-2017 11:45 AM[/TD]
[TD]21:05:39

[/TD]
[/TR]
</tbody><colgroup><col><col><col></colgroup>[/TABLE]

 

[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-->