Dec 09 2022 08:00 AM
Hi, hoping someone can help
I have two dates which I need to calculate the difference between the two date and time fields, I also need to exclude weekends.
Start Date format dd/mm/yyyy hh:mm
End date format dd/mm/yyyy hh:mm
I have tried using NETWORKDAYS but I need the output to be in HH:MM format not whole days. I've tried a number of suggestions via web searches but they don't work.
Any advice would be most welcome
Dec 09 2022 09:41 AM
Dec 09 2022 12:24 PM
Dec 11 2022 07:01 AM
Here's an example data set
(Column C / Row 2) Call Date (Column D / Row 2) Response date
2022/1/11 20:56 2022/1/12 0:14
What I need to do is calculate the difference between the two dates excluding weekends with the output data to be [h]:mm:ss as I have 600 rows of information which I need to average out.
Dec 11 2022 07:30 AM
Dec 12 2022 02:54 AM
Dec 12 2022 05:27 AM