Good Morning
I have an issue. I've been trying to create a formula to count the number of instances a particular time range appears in a column on a spreadsheet.
Column C contains manually entered times followed by AM or PM. One problem I've run into that may or may not be effecting the formula's I've tried is that the time formats are different in some columns.
Example
Data Type = General
12:17 PM
Example
Data Type = Custom
12:02:00 PM
I've tried many methods to make them all the same format. I would prefer the one with the General data type.
I tried converting the data type. Copying and pasting one with the format I wanted and change it in the cell, no luck.
=SUMIFS(A:A,">=6:00AM", A:A, "<3:00PM")
My desired results were not yielded from that formula. I've tried other formulas without the correct result either. I don't want to manually count over 350 times.
I have an issue. I've been trying to create a formula to count the number of instances a particular time range appears in a column on a spreadsheet.
Column C contains manually entered times followed by AM or PM. One problem I've run into that may or may not be effecting the formula's I've tried is that the time formats are different in some columns.
Example
Data Type = General
12:17 PM
Example
Data Type = Custom
12:02:00 PM
I've tried many methods to make them all the same format. I would prefer the one with the General data type.
I tried converting the data type. Copying and pasting one with the format I wanted and change it in the cell, no luck.
=SUMIFS(A:A,">=6:00AM", A:A, "<3:00PM")
My desired results were not yielded from that formula. I've tried other formulas without the correct result either. I don't want to manually count over 350 times.