Sum specific hours in an entire spreadsheet

TreetrunksMM 

To count the number of times a specific hour appears in a range of cells, you can use the following formula:

=COUNTIF(range, ">="&TIME(hour,0,0)&"<"&TIME(hour+1,0,0))

Here's how you can apply it to your scenario:

1. Assuming your time entries are in a range of cells, for example, A2:A1000, adjust the range in the formula to match your actual data range.
2. In the cell where you want to display the count for a specific hour, enter the formula:

=COUNTIF(A2:A1000, ">="&TIME(hour,0,0)&"<"&TIME(hour+1,0,0))

Replace hour with the desired hour (e.g., 6 for 6:00 to 6:59).

1. Copy the formula to the cells for other hours.

The formula compares each time entry in the range to the specified hour range and counts the instances that fall within that hour.

Make sure that the time values in the range are recognized as actual times (not text) by Excel. You can format the cells as time to ensure proper recognition.

Note: If you have multiple columns for different people and you want to count the occurrences across all columns, you can adjust the range to include all relevant columns (e.g., A2:C1000).

Hope I got it right. otherwise please add more detailed information. Step by step (cell by cell) description, a photo or a file (without sensitive data) would help. Excel version, operating system, storage medium, etc. would also help.