Average Timing

%3CLINGO-SUB%20id%3D%22lingo-sub-3111283%22%20slang%3D%22en-US%22%3EAverage%20Timing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3111283%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20find%20average%20timing%20for%20the%20low%20and%20peak%20hours%20of%20my%20shop.%3C%2FP%3E%3CP%3EIs%20there%20a%20formula%20that%20can%20give%20me%20the%20average%20timing%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20noted%20down%20the%20peak%20and%20low%20periods%20for%20Monday%20to%20Fridays.%3C%2FP%3E%3CP%3EI%20want%20to%20find%20out%20what's%20the%20average%20timing%20for%20Monday%20peak%20hours%20would%20be.%3C%2FP%3E%3CP%3EThis%20is%20what%20my%20sheet%20looks%20like.%20If%20we%20look%20at%20Tuesday%2C%20the%20mode%20would%20be%208am-ish.%3C%2FP%3E%3CP%3EIs%20there%20a%20for%20me%20to%20find%20formulate%20in%20a%20way%20that%20I%20get%208-845%20as%20a%20result%20for%20Tuesdays.%3C%2FP%3E%3CP%3ENot%20sure%20if%20you%20guys%20are%20able%20to%20understand%20what%20I%20am%20asking.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22sample.PNG%22%20style%3D%22width%3A%20776px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F345024i7BD3E6B56B639F35%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22sample.PNG%22%20alt%3D%22sample.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3111283%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi,

 

I am trying to find average timing for the low and peak hours of my shop.

Is there a formula that can give me the average timing?

 

I have noted down the peak and low periods for Monday to Fridays.

I want to find out what's the average timing for Monday peak hours would be.

This is what my sheet looks like. If we look at Tuesday, the mode would be 8am-ish.

Is there a for me to find formulate in a way that I get 8-845 as a result for Tuesdays.

Not sure if you guys are able to understand what I am asking.

sample.PNG

 

0 Replies