Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / July 2007

Tip: Looking for answers? Try searching our database.

Time Formula Help Pls.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sapphyre - 12 Jul 2007 16:52 GMT
Sorry if this post already showed up.  I could'nt find my first post anywhere
:/

Anyways, my question is how can I make a formula calculate how many
occurances of a specific time frame happened in Sheet 1, column A, and put it
in Sheet 2, column A, B, C?

Example of the colums I'm speaking of:

Sheet 1:
       A                                      
START TIME (Header)
07/01/07 03:00
07/01/07 05:50
07/01/07 07:00
07/01/07 11:00
07/01/07 15:10
07/01/07 18:37
07/01/07 23:01

Sheet 2:
        A                          B                            C
7a-3p (Header)          3p-11p (Header)      11p-7a (Header)
        2                          2                             3

So I need to know how to create a formula that will calculate sheet 2, A,B,C
(with the 2,2,3 I typed in) from data on Sheet 1, A.

Any help would be appreciated.
Thank you.
Jeff Boyce - 12 Jul 2007 16:58 GMT
You've reached a newsgroup dedicated to supporting Microsoft Access, the
relational database product.  Your question appears to be related to
spreadsheets.

Try reposting in a spreadsheet-related newsgroup.

Regards

Jeff Boyce
Microsoft Office/Access MVP

> Sorry if this post already showed up.  I could'nt find my first post
> anywhere
[quoted text clipped - 29 lines]
> Any help would be appreciated.
> Thank you.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.