Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Nancy L
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to add top 4 entries in a column and total them at the bot New2excel Excel Worksheet Functions 2 January 7th 06 06:18 AM
Greater than formula Tracey Excel Worksheet Functions 2 January 5th 06 10:02 PM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 06:18 PM
formula for Greater of C or D X E [email protected] Excel Discussion (Misc queries) 2 October 11th 05 07:26 PM
Formula which is greater tahn or equal to zero bruce2444 Excel Worksheet Functions 2 September 7th 05 12:24 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"