| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting cells within certain time frames - 24 hour clock
I am looking to count the number of cells that meet criteria in a 24 hour
clock format. The cell range is C2:C1395. If a time falls between 00:00:00 and 00:59:59, I want to count it. This would continue for the remaining 23 hours I was able to get this to work at one point using COUNTIF, but now it is not functioning and an error keeps appearing. Also, would it make a difference in the formula if I was using Excel 03 versus 07? Thanks for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I subtract time where hh:mm:ss:ff (frames = 30 frames/sec) | Excel Discussion (Misc queries) | |||
| 24 hour clock formula for elapsed time between 1215 and 1630 | Excel Worksheet Functions | |||
| Counting time-frames | Excel Discussion (Misc queries) | |||
| time diffrence with 24 hour clock | Excel Worksheet Functions | |||
| Counting the number of cells within a certain hour. | Excel Discussion (Misc queries) | |||
Threaded Mode
