Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Does anyone know how to use the countif (or a correct funtion) to count the
number of times a "time value" shows up in a series? For example, the series J1-J100 is made of up time formated fields. The fields have 1:03AM, 2:15AM, 4:15PM, etc in them. I want to count how many times 1:**AM shows up in the series. I am guessing it is something like countif(J1:J100, "1*AM"), but that doesn't seem to work. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Entering Times | Excel Discussion (Misc queries) | |||
Time sheets | Excel Worksheet Functions | |||
Formula for a time card | Excel Worksheet Functions | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
Countif ??? | Excel Worksheet Functions |