call logging between hours

**mahsalti** · 06-02-2011, 08:02 AM

I'm fairly new to using excel.

What I'm trying to do now is: I have a list of calls that came in during the day, these are about 200 calls (197 to be accurate) and what I need to do is with the call data is create a column and see how many calls came in during certain hours,

I've tried creating a column but due to my lack of experience I don't know what to do, I was hoping someone could direct me somehow,

Any questions are welcome! I very much appreciate it!

ps: I'm using excel 2010

this is the data I have:

Call date
2011/6/1 0:07
2011/6/1 1:19
2011/6/1 1:22
2011/6/1 2:14
2011/6/1 2:16
2011/6/1 2:23
2011/6/1 2:26
2011/6/1 2:34
2011/6/1 6:56
2011/6/1 7:25
2011/6/1 7:25
2011/6/1 7:34
2011/6/1 7:41
2011/6/1 7:53
2011/6/1 7:59
2011/6/1 8:07
2011/6/1 8:20
2011/6/1 8:25
2011/6/1 8:25
2011/6/1 8:37
2011/6/1 8:44
2011/6/1 8:51
2011/6/1 8:53
2011/6/1 8:54
2011/6/1 9:03
2011/6/1 9:03
2011/6/1 9:05
2011/6/1 9:12
2011/6/1 9:18
2011/6/1 9:19
2011/6/1 9:28
2011/6/1 9:29
2011/6/1 9:32
2011/6/1 9:40
2011/6/1 9:42
2011/6/1 9:42
2011/6/1 9:45
2011/6/1 9:46
2011/6/1 9:54
2011/6/1 9:56
2011/6/1 9:56
2011/6/1 9:57
2011/6/1 10:02
2011/6/1 10:06
2011/6/1 10:07
2011/6/1 10:08
2011/6/1 10:10
2011/6/1 10:11
2011/6/1 10:13
2011/6/1 10:13
2011/6/1 10:13
2011/6/1 10:17
2011/6/1 10:19
2011/6/1 10:22
2011/6/1 10:23
2011/6/1 10:23
2011/6/1 10:31
2011/6/1 10:38
2011/6/1 10:38
2011/6/1 10:41
2011/6/1 10:46
2011/6/1 10:47
2011/6/1 10:48
2011/6/1 10:50
2011/6/1 10:52
2011/6/1 10:55
2011/6/1 10:56
2011/6/1 10:57
2011/6/1 10:59
2011/6/1 11:06
2011/6/1 11:13
2011/6/1 11:13
2011/6/1 11:15
2011/6/1 11:17
2011/6/1 11:17
2011/6/1 11:25
2011/6/1 11:26
2011/6/1 11:29
2011/6/1 11:31
2011/6/1 11:38
2011/6/1 11:39
2011/6/1 11:42
2011/6/1 11:52
2011/6/1 11:56
2011/6/1 11:59
2011/6/1 11:59
2011/6/1 12:11
2011/6/1 12:20
2011/6/1 12:34
2011/6/1 12:36
2011/6/1 12:41
2011/6/1 12:48
2011/6/1 12:54
2011/6/1 12:56
2011/6/1 13:03
2011/6/1 13:05
2011/6/1 13:10
2011/6/1 13:14
2011/6/1 13:16
2011/6/1 13:19
2011/6/1 13:21
2011/6/1 13:22
2011/6/1 13:24
2011/6/1 13:25
2011/6/1 13:30
2011/6/1 13:35
2011/6/1 13:39
2011/6/1 13:46
2011/6/1 13:56
2011/6/1 13:56
2011/6/1 14:02
2011/6/1 14:13
2011/6/1 14:18
2011/6/1 14:22
2011/6/1 14:26
2011/6/1 14:27
2011/6/1 14:27
2011/6/1 14:27
2011/6/1 14:28
2011/6/1 14:30
2011/6/1 14:41
2011/6/1 14:44
2011/6/1 14:45
2011/6/1 14:47
2011/6/1 14:47
2011/6/1 14:53
2011/6/1 15:00
2011/6/1 15:03
2011/6/1 15:05
2011/6/1 15:19
2011/6/1 15:21
2011/6/1 15:21
2011/6/1 15:33
2011/6/1 15:34
2011/6/1 15:37
2011/6/1 15:41
2011/6/1 15:41
2011/6/1 15:42
2011/6/1 15:44
2011/6/1 15:50
2011/6/1 15:54
2011/6/1 15:58
2011/6/1 16:05
2011/6/1 16:10
2011/6/1 16:12
2011/6/1 16:15
2011/6/1 16:20
2011/6/1 16:20
2011/6/1 16:22
2011/6/1 16:25
2011/6/1 16:32
2011/6/1 16:38
2011/6/1 16:38
2011/6/1 16:41
2011/6/1 16:45
2011/6/1 16:46
2011/6/1 16:50
2011/6/1 16:51
2011/6/1 16:52
2011/6/1 16:53
2011/6/1 16:56
2011/6/1 17:03
2011/6/1 17:10
2011/6/1 17:11
2011/6/1 17:12
2011/6/1 17:14
2011/6/1 17:17
2011/6/1 17:27
2011/6/1 17:27
2011/6/1 17:29
2011/6/1 17:42
2011/6/1 17:46
2011/6/1 17:49
2011/6/1 18:23
2011/6/1 18:34
2011/6/1 18:43
2011/6/1 18:52
2011/6/1 19:10
2011/6/1 19:15
2011/6/1 19:19
2011/6/1 19:31
2011/6/1 19:35
2011/6/1 20:32
2011/6/1 21:19
2011/6/1 21:20
2011/6/1 21:25
2011/6/1 21:40
2011/6/1 21:50
2011/6/1 21:52
2011/6/1 21:58
2011/6/1 22:28
2011/6/1 22:33
2011/6/1 23:14
2011/6/1 23:19
2011/6/1 23:43
2011/6/1 23:45
2011/6/1 23:48
2011/6/1 23:50

**mahsalti** · 06-02-2011, 08:07 AM

Maybe if I first do something like this it will work out.. so it will show calls are logged between certain hours

http://www.excelforum.com/excel-new-...ain-hours.html

and from that data... let me try this out, i'll keep things posted here

**pblnrao** · 06-02-2011, 09:19 AM

Hi mahsalti,

Chk the attached excel, i think it solves your purpose.

As u said u r new to Excel. Dont delete Column I, J,K (Hide These Columns for good appearance). As they are used to extract for getting final result. These are used as references in Column C & D.

Regards,
PBL