Forum Discussion
Formula for Filtered Time Average
I used =TEXT(G2-G3,"[h]:m") in Office 2016 to calculate the delivery time between stages for multiple orders. Now I have filtered the various stages of the order delivery to only show deliveries betw...
Hi,
All that functions work with numbers, not text. If you add in your column G2-G3 applying proper format (instead of TEXT(G2-G3,..)) it shall work.