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
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
A | B | C | D | E | F | G | H | I | |
DateTime | Date | Time | Time by hour | Day | Column1 | Day of the Week | Count | 9:00:00 AM | 0 |
1/07/2021 2:24:06 PM | 0/01/1900 | 2:24:06 PM | 2:00:00 PM | Thursday | 2:24:06 PM | Monday | 28 | 10:00:00 AM | 0 |
1/07/2021 1:52:33 PM | 0/01/1900 | 1:52:33 PM | 1:00:00 PM | Thursday | 1:52:33 PM | Tuesday | 36 | 11:00:00 AM | 0 |
1/07/2021 12:29:58 PM | 0/01/1900 | 12:29:58 PM | 12:00:00 PM | Thursday | 12:29:58 PM | Wednesday | 37 | 12:00:00 PM | 0 |
30/06/2021 3:08:35 PM | 0/01/1900 | 3:08:35 PM | 3:00:00 PM | Wednesday | 3:08:35 PM | Thursday | 41 | 1:00:00 PM | 0 |
30/06/2021 1:00:16 PM | 0/01/1900 | 1:00:16 PM | 1:00:00 PM | Wednesday | 1:00:16 PM | Friday | 29 | 2:00:00 PM | 0 |
29/06/2021 2:49:37 PM | 0/01/1900 | 2:49:37 PM | 2:00:00 PM | Tuesday | 2:49:37 PM | 3:00:00 PM | 0 |