stephenohear
New Member
- Joined
- Aug 28, 2017
- Messages
- 5
Hi good folks. Greetings from Scotland.
I have a question regarding network days, I've searched the forum but cant find an answer that is looks right.
In the table below I'm trying to calculate the response between the 2 times below, based on a working day of 08:00 to 18:00, and should include weekends.
So as below, call is logged on Friday 5th at 08:50am (cell A1) and closed on the Tuesday at 13:50pm (cell B1).
I'm using excel 2016.
Any assistance would be most appreciated.
Thanks.
[TABLE="width: 500"]
<tbody>[TR]
[TD]05/01/2018 08:50:37[/TD]
[TD]09/01/2018 13:50:37[/TD]
[TD]Formula??[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have a question regarding network days, I've searched the forum but cant find an answer that is looks right.
In the table below I'm trying to calculate the response between the 2 times below, based on a working day of 08:00 to 18:00, and should include weekends.
So as below, call is logged on Friday 5th at 08:50am (cell A1) and closed on the Tuesday at 13:50pm (cell B1).
I'm using excel 2016.
Any assistance would be most appreciated.
Thanks.
[TABLE="width: 500"]
<tbody>[TR]
[TD]05/01/2018 08:50:37[/TD]
[TD]09/01/2018 13:50:37[/TD]
[TD]Formula??[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]