time difference excluding weekend

[Sathisc]

Hi,

I have a huge data with date and time between 1activity and the other. I am searching for a formula to find out the "hour, Minutes and Seconds" difference excluding weekends(Saturday and Sunday)

[TABLE="width: 306"]
<tbody>[TR]
[TD]1st Activity[/TD]
[TD]2nd Activity[/TD]
[TD]Time Difference[/TD]
[/TR]
[TR]
[TD]09-30-17 22:54[/TD]
[TD]10-01-17 08:21[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]09-23-17 00:42[/TD]
[TD]09-23-17 19:37[/TD]
[TD] [/TD]
[/TR]
</tbody><colgroup><col span="2"><col></colgroup>[/TABLE]


Thanks in advance
Sathish Kumar C

 

[jkpieterse]

Have a look at the NETWORKDAYS function.

 

[barry houdini]

See my answer here

https://www.mrexcel.com/forum/excel...ate-falls-weekend-but-start-date-weekday.html