ExcelBanter - Formula for number of entries in colum that are greater than 2 hr

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Formula for number of entries in colum that are greater than 2 hr (https://www.excelbanter.com/new-users-excel/68248-formula-number-entries-colum-greater-than-2-hr.html)

Nancy L

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

Dave Peterson

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

All times are GMT +1. The time now is 03:23 PM.