Time query to find number of times in a certain range

**aloha31** · 08-13-2013, 01:59 PM

Hello all,

So I am trying to devise a code that will allow a user to input a range of times via dialog box. Then with this range (a startTime and endTime), the VBA code will search the worksheet and count the number of trips that take place in that time interval. I can't figure out a way to convert the user entry into a h:mm AM/PM format but I feel like I am on the right track.

If anyone could take a look at my attached code/file and steer me in the right direction, that would be awesome! I would also be happy to clarify anything I left out, thank you.

-Chad

Please Login or Register  to view this content.

timequery.xlsm

**AB33** · 08-13-2013, 02:50 PM

Please Login or Register  to view this content.

fromTime is not defined as a cell or range. You need to format it a cell or range first before you test it with if.

**aloha31** · 08-13-2013, 04:18 PM

Please Login or Register  to view this content.

This code works for one column of times, however when I enter a range of times outside the specified row, count1 always returns "0" trips. How can I have it search multiple columns of time?

**AB33** · 08-13-2013, 04:32 PM

May be this line if worktotalDXdept1 is a named range

Please Login or Register  to view this content.

**aloha31** · 08-13-2013, 04:41 PM

The number of items in it's column will always vary, so I'm not sure that would work out the way I'm hoping. I am trying to define fromTime and toTime as a range, but since these variables refer to the string of text from the userform's text box, I'm kind of confused how that would work. I feel like I'm so close to getting this thing right. Am I headed in the right direction? Still getting an error (Expected: Expression) with this:

Please Login or Register  to view this content.

Thank you for your help so far, AB33. Please let me know if you need any additional info. Please refer to this updated file: Book4.xlsm

**AB33** · 08-13-2013, 04:46 PM

Sorry!
I can not test it, but you need to remove the hashes from these lines

Please Login or Register  to view this content.

You may putin dates in hashes but not any other.

Time query to find number of times in a certain range

LinkBack

Thread Tools

Rate This Thread

Display

Time query to find number of times in a certain range

Re: Time query to find number of times in a certain range

Re: Time query to find number of times in a certain range

Re: Time query to find number of times in a certain range

Re: Time query to find number of times in a certain range

Re: Time query to find number of times in a certain range

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] find number of times a letter or a number appears in a column

Query around time formats and addition of times with large numbers

Excel 2007 : How do I find the number of times a time appears in a report ?

Formula to find number of instances between a time range

Time (clock) times a number= very high number?

Bookmarks

Bookmarks

Posting Permissions