Calling all Excel Gurus!

Colbaker · 7 Jul 2015 at 20:13

Hi All,

I wonder if you could help me with a little Excel problem i am having, First please see this picture....

The above worksheet puts times that phone calls come through, I am looking at finding out when the peak hours are during the day, Would this require some sort of pivot table? If so how would i go about that as i have tried and can't get it to work, Or alternatively can a formula do it?

Thanks all.

spoffle · 7 Jul 2015 at 20:25

Ooh I'm tellin'! We all know what that red bar means at the top of Office applications!

Colbaker · 7 Jul 2015 at 20:39

spoffle said:
Ooh I'm tellin'! We all know what that red bar means at the top of Office applications!

Lol.

d_brennen · 7 Jul 2015 at 20:42

I don't get it, there's one time per day?

Participant · 7 Jul 2015 at 20:48

^ The question is when the peak times are across all days.

I would do an =HOUR formula on the times then pivot chart with a count of hours by hour.

Edit - assuming the data volume justifies it. Like this:

Colbaker · 7 Jul 2015 at 21:37

Participant said:
^ The question is when the peak times are across all days.

I would do an =HOUR formula on the times then pivot chart with a count of hours by hour.

Edit - assuming the data volume justifies it. Like this:

What formula did you use in regards to the =HOUR function ad I have never used that?

Participant · 7 Jul 2015 at 21:48

=HOUR([cell with time in it)