+ Reply to Thread
Results 1 to 2 of 2

[SOLVED] Formula for number of entries in colum that are greater than 2 hr

  1. #1
    Nancy L
    Guest

    [SOLVED] 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. #2
    Dave Peterson
    Guest

    Re: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1