Mar 23 2022 12:34 PM
I need to calculate Hours, Minutes, Seconds from date/time stamps to find the duration then from the duration find the average. I've attached a screen shot for reference with all of the results coming out at hh:mm:ss
Order Date time:
01 02:23:47
<day> <hour>:<minute>:<second>
Order Delivery Time:
<day> <hour>:<minute>:<second>
There would be 3 equations that would need to be averaged
1. Placed Order with vendor datetime (minus) customer place order datetime = duration
2. Trucker at Vendor datetime (minus) Placed order with vendor datetime = duration
3. Delivered to customer datetime (minus) Trucker at Vendor datetime = duration
Then all 3 of these I would need to average separately. Hopefully that makes sense.
Greatly appreciate any and all help!
Mar 23 2022 12:47 PM
SolutionMar 23 2022 12:56 PM
Mar 23 2022 01:06 PM
Mar 23 2022 01:13 PM
Mar 23 2022 01:14 PM
Mar 23 2022 01:15 PM
Mar 24 2022 04:13 AM
If with newly introduced for Insiders functions that could be
=SUM( TEXTSPLIT(B1, " ") - TEXTSPLIT(A1, " ") )
with applying dd hh:mm:ss format
Mar 23 2022 12:47 PM
Solution