Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
counting how many times something happens in a week | Excel Discussion (Misc queries) | |||
How to generate same event (has 2 possible outcomes) 200 times? | Excel Discussion (Misc queries) | |||
Counting number of times a value occurs | Excel Discussion (Misc queries) | |||
Counting the times a number appears | Excel Discussion (Misc queries) | |||
Counting cells with a specified frequency(how many times it appear | Excel Discussion (Misc queries) |