How to calculate frequency of event by hours

ScottDrad

New Member
Joined
Aug 10, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Good Evening
Ive been trying to get my excel spreadsheet to calculate the frequencey of an event by hours using the Time Stamp
I have used this formumla =COUNTIF(D$2:D$172,I7) but it return a value of zero
I have also tried to use the frequency function but both return a value of zero, Im pretty sure it is the time stamp is converted to a number
Any help would be much appreciated
ABCDEFGHI
DateTimeDateTimeTime by hourDayColumn1Day of the WeekCount9:00:00 AM
0​
1/07/2021 2:24:06 PM0/01/19002:24:06 PM2:00:00 PMThursday
2:24:06 PM​
Monday
28​
10:00:00 AM
0​
1/07/2021 1:52:33 PM0/01/19001:52:33 PM1:00:00 PMThursday
1:52:33 PM​
Tuesday
36​
11:00:00 AM
0​
1/07/2021 12:29:58 PM0/01/190012:29:58 PM12:00:00 PMThursday
12:29:58 PM​
Wednesday
37​
12:00:00 PM
0​
30/06/2021 3:08:35 PM0/01/19003:08:35 PM3:00:00 PMWednesday
3:08:35 PM​
Thursday
41​
1:00:00 PM
0​
30/06/2021 1:00:16 PM0/01/19001:00:16 PM1:00:00 PMWednesday
1:00:16 PM​
Friday
29​
2:00:00 PM
0​
29/06/2021 2:49:37 PM0/01/19002:49:37 PM2:00:00 PMTuesday
2:49:37 PM​
3:00:00 PM
0​
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Forum statistics

Threads
1,223,911
Messages
6,175,324
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top