Forum Discussion

TorryG's avatar
TorryG
Copper Contributor
Aug 02, 2023

Time Difference Averaging

Is there a formula to calculate the average time difference between cells with date & time stamps?

 

Example: If I have the below timestamps in 4 cells, there would be time differences of 106s, 53s, & 387s. The average of those time differences then would be (106+53+387)/3 = 182s.

8-1-2023 13:17:18

8-1-2023 13:19:04

8-1-2023 13:19:57

8-1-2023 13:26:24

1 Reply

Resources