Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula for number of entries in colum that are greater than 2 hr
I'm fairly new to excel and need a formula that will tell me the number of
time entries in a very long column that are greater than 2 hours. Using Excel 2003 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula for number of entries in colum that are greater than 2 hr
=countif(a:a,""&time(2,0,0))
Nancy L wrote: I'm fairly new to excel and need a formula that will tell me the number of time entries in a very long column that are greater than 2 hours. Using Excel 2003 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to add top 4 entries in a column and total them at the bot | Excel Worksheet Functions | |||
Greater than formula | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
formula for Greater of C or D X E | Excel Discussion (Misc queries) | |||
Formula which is greater tahn or equal to zero | Excel Worksheet Functions |