LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 42
Default Counting event times

In a workbook, dates and times for events are kept in columns, each column
representing the number times the events have occurred for the item in that
row. In this workbook the item in the row would be an address.

I need to break down the entered data by the hour such as 09:00, 10:00,
11:00, etc. The following is an example of the entries:

5/24 12:57 7/26 08:28
5/17 02:02 6/14 01:33 9/20 03:50
4/18 17:52 9/8 16:15 10/30 20:51 11/11 08:56
7/3 21:16
1/4 08:12 3/13 06:05 8/7 00:11 9/9 03:33

Thank you for your suggestions.
 
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
counting how many times something happens in a week lukesdad Excel Discussion (Misc queries) 2 May 22nd 09 04:17 PM
How to generate same event (has 2 possible outcomes) 200 times? lnwdros Excel Discussion (Misc queries) 1 November 17th 08 02:28 AM
Counting number of times a value occurs da Excel Discussion (Misc queries) 6 September 9th 08 03:51 PM
Counting the times a number appears Jennifer B[_2_] Excel Discussion (Misc queries) 2 July 17th 08 11:54 PM
Counting cells with a specified frequency(how many times it appear Kelvin Excel Discussion (Misc queries) 0 July 13th 05 08:36 AM


All times are GMT +1. The time now is 12:45 PM.

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

About Us

"It's about Microsoft Excel"