I'm a newbie and would like the assistance of the Guru's that frequent this board.
For each day of the week ,I would like to count the number of times for each hour on each day. ie. Sun @ 0hr(12a),@1hr,@2hr... and the same for Mon.,Tue.,Wed.,... p.s. these spreadsheets are 40k to60k rows deep.
Day of Wk.....Date........Time
Fri..............5/5/2006.....0:02
Thu...........5/11/2006.....0:04
Sun............5/7/2006.....0:06
Tue...........5/30/2006.....0:08
Thu.............5/4/2006.....0:10
Mon.............5/1/2006.....0:12
Sat............5/13/2006.....0:14
Mon...........5/15/2006.....0:16
Sun...........5/28/2006.....0:20
Fri...............5/5/2006.....0:22
Tue...........5/30/2006.....0:24
Sat............5/20/2006.....0:42
Mon...........5/22/2006.....0:46
Tue.............5/9/2006.....0:54
Sat..............5/6/2006.....0:56
Wed............5/3/2006.....1:00
Mon............5/1/2006.....1:00
Thu...........5/18/2006.....1:30
Mon............5/1/2006.....1:30
Thu...........5/18/2006.....1:58
Sun...........5/14/2006.....2:10
Sat.............5/6/2006.....2:36
Tue...........5/16/2006.....3:24
Sat............5/20/2006.....3:30
Mon...........5/15/2006.....7:32
Wed...........5/17/2006.....11:04
Thanks!
For each day of the week ,I would like to count the number of times for each hour on each day. ie. Sun @ 0hr(12a),@1hr,@2hr... and the same for Mon.,Tue.,Wed.,... p.s. these spreadsheets are 40k to60k rows deep.
Day of Wk.....Date........Time
Fri..............5/5/2006.....0:02
Thu...........5/11/2006.....0:04
Sun............5/7/2006.....0:06
Tue...........5/30/2006.....0:08
Thu.............5/4/2006.....0:10
Mon.............5/1/2006.....0:12
Sat............5/13/2006.....0:14
Mon...........5/15/2006.....0:16
Sun...........5/28/2006.....0:20
Fri...............5/5/2006.....0:22
Tue...........5/30/2006.....0:24
Sat............5/20/2006.....0:42
Mon...........5/22/2006.....0:46
Tue.............5/9/2006.....0:54
Sat..............5/6/2006.....0:56
Wed............5/3/2006.....1:00
Mon............5/1/2006.....1:00
Thu...........5/18/2006.....1:30
Mon............5/1/2006.....1:30
Thu...........5/18/2006.....1:58
Sun...........5/14/2006.....2:10
Sat.............5/6/2006.....2:36
Tue...........5/16/2006.....3:24
Sat............5/20/2006.....3:30
Mon...........5/15/2006.....7:32
Wed...........5/17/2006.....11:04
Thanks!