timestamp grouped as time interval

hi everyone,

I've got a lot of table of recorded phone calls.

PHONE CALLS(callid, time, purpose)

and i want to create a query to count these calls grouped by half hour
interval like:

Time Period           Total Calls
------------------          -----------------
9:00-9:30                     25
9:30-10:00                   40
10:00-10:30                  55

is there a way to do this?

--Stefano
0
buattis
12/19/2007 2:08:05 AM
access.queries 6343 articles. 1 followers. Follow

1 Replies
1827 Views

Similar Articles

[PageSpeed] 48

You can find the int of the time * 48 since there are 48 half hours in a day. 
Then divide by 48.
 Format(Int([TimeField]*48)/48,"Short Time")

-- 
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP 
http://www.access.hookom.net/UCP/Default.htm


"buattis@anz.com" wrote:

> hi everyone,
> 
> I've got a lot of table of recorded phone calls.
> 
> PHONE CALLS(callid, time, purpose)
> 
> and i want to create a query to count these calls grouped by half hour
> interval like:
> 
> Time Period           Total Calls
> ------------------          -----------------
> 9:00-9:30                     25
> 9:30-10:00                   40
> 10:00-10:30                  55
> 
> is there a way to do this?
> 
> --Stefano
> 
0
Utf
12/19/2007 4:09:00 AM
Reply:

Similar Artilces:

Excel crashez every time i open a worksheet with formulas
I would apreciate your help, thank you. I have Windows Vista Businees x86, Microsoft Office Basic 2007. The problem first appeared when i reinstalled everything a few days ago. The steps i took are the folowing: Format c: -> Reinstal Vista(internet cabe unpluged) -> install Office -> start Office - > open worksheet(any worksheet) -> Office crashes I also tried the folowing: Format c: -> Reinstal Vista(internet cabe unpluged) -> install SP1 then SP2 -> install Office -> install updates(windows Update) -> all updates installed-> start Office - > open wo...

resource time
Hi, Is there documented information (MS or other) for how much resource time is required to support common exchange server and client tasks? Basically the day to day tasks. The only documented information i have come across is that it takes about .25 Administrators for every 100 users. thanks. wow, where did you find that statistic? I'd like to show it to my boss...I single-handedly support over 8,000 users here, and also assist with support for two remote sites...that being said, Exchange support (excluding support for Outlook issues, which is a lot of what I have to do) boils down...

outlook Reply TimeStamp
hello every one, I want to know if there is a posibility to check the timestamp of the "Reply at:" With kind regards Raul You want the reply time from the original item? Not exposed in the Outlook object model. You can use another API such as Redemption (www.dimastr.com/redemption) or the PropertyAccessor in Outlook 2007 or 2010 to see if a reply was the last action, and the time of that action. If PR_LAST_VERB_EXECUTED (0x10810003 or "http://schemas.microsoft.com/mapi/proptag/0x10810003") is 102 (EXCHIVERB_REPLYTOSENDER) the last action was a r...

Mailbox permssions from one storage group to another
I have two storage groups, each with one mailbox store. The first storage group contains a public folder store. All of the permissions for the users in the first storage appear to be correct and functioning normally. Everyone in the second storage group looks to have much different inherited mailbox permissions that don't look to be correct. Almost all of the groups including administrator, enterprise admin, exchange domain server have inherited allow AND deny for full mailbox access. Is this correct? I doesn't seem right to me... Where do you change what inherited rights are aqu...

Method to group lines
Hi, I have this kind of sheet: 1?? AA1 2?? BB1 3?? CC1 3?? CC2 3?? CC3 3?? CC4 3?? CC5 2?? BB2 3?? CC6 3?? CC7 3?? CC8 1?? AA2 2?? BB3 3?? CC9 3?? CC10 3?? CC11 every rows it's a cell. The first number is the level of depth. How can I group group the rows by the level? I need to use the function "Group" of Excel, so I can hide/show rows. In this way I would see, before all the 1 then I expand them and I see only the 2 and so on... Thanks in advance for your help! -- Ciao BlackSun I usally add 3 auxilary column to the worksheet.. these could ...

Outlook 2007: Contact "Groups"
I am getting a bit confused with contact groups and folders. I created a new group and then created a main folder within that group. I then imported some contacts into that main folder from Excel. Then, I decided to make additional folders within that new group for a total of about six folders. Somehow I deleted the folders from the navigation pane but they still appear in the address book? How do I get them back in the navigation pane? Also, I see that five of the folders are indented from the "main folder". Why is that? I wanted multiple folders at the same level. ...

Time chart
I need a time chart as in example A1= Henry B1=15 C1=21 A2= Sally B2=12 C2-=18 A3= George B3=11 C3=16 A4= Alex B4=10 C4=14 Henry ------------------------ Sally ----------------------- George -------------------- Alex ----------------- 10 11 12 13 14 15 16 17 18 19 20 21 You could simulate the chart with an XY Scatter chart of the data 15 4 21 4 12 3 18 3 11 2 16 2 10 1 14 1 Format the y-axes to show no labe...

saving the same file in different places at a time
hi, i have an excel file in one system when i update this file, is it possible some range of cells in this file to be saved in the different system also how do i give a link to the other file? appreciate, if anyone could help Sounds like you want to paste a link so that the cell will update every time the other cell gets new info... To do this, say you want to link cell A1 to cell A7...click on cell A7 and click copy...Go to cell A1 and click paste...Then (if you have Excel 2003), click on Edit/Paste Special/Paste Link and you now have youe link...The "Paste Link" Button ...

Time input mask format
If I input - "340 a", I want it to show "3:40 AM" or if I input 1230 p, I want it formated as 12:30 PM can this be done? enter your times as 3:40 or 12:30 and set the format of the cell to show it as am or pm format ,,,, cells,,,,custom,,, h:mm AM/PM "WNB-96740" wrote: > If I input - "340 a", I want it to show "3:40 AM" > > or if I input 1230 p, I want it formated as 12:30 PM > > can this be done? There is no way to set up an input mask as you describe without using VBA. See Chip Pearson's site for quicken...

Multiple time ranges
I am trying to create a formula that will look up the time values and return a letter. Times are in column F. Must include seconds (as values does include seconds). 07:00:00 - 17:30:00 = "A" 17:31:00 - 00:30:00 = "B" 00:31:00 - 06:59:00 = "C" <as values does include seconds).> But you miss out whole minutes in your specications. Anyway, this should work, but do check your threshold values. Maybe you need to add a second or less than a second. Set up a table like this (in this example: A1:B4) 0:00:00 B 0:30:00 C 7:00:00 A 17:30:00 B With your time to l...

How do I set up a template to save time typing names
I have to send a lot of e-mails to the same people, and always more than one person. How do I set up a template so that I don't have to keep typing who it is to and who I am 'Cc' to? traceyella <traceyella@discussions.microsoft.com> wrote: > I have to send a lot of e-mails to the same people, and always more > than one person. How do I set up a template so that I don't have to > keep typing who it is to and who I am 'Cc' to? Create your message, but instead of sending it, save it as an OFT. WHen you want to send it, forward it from your Drafts fold...

Length of time to publish
Does anyone know why it takes a very long time to publish my websites ? Is it something I'm doing wrong or is my computer slow ? Many variables. The speed of your internet connection. Traffic on the internet. And, the host may have it throttled to a certain amount. -- Tom [Pepper] Willett Microsoft MVP - FrontPage Since 1997 --------------------------- "mousey" <mousey@discussions.microsoft.com> wrote in message news:90A5062A-42EB-4039-8E24-20D26F260CB7@microsoft.com... : Does anyone know why it takes a very long time to publish my websites ? : Is it someth...

Strange. Deleted Journal and Time Clock
I just tried to do payroll and all of my payroll entries before 7/1/07 are gone. Also the journals before that date are also missing. All of my items are still in my register list. What gives? ...

Pre-Windows 2000 Compatible Group
Hi, Can anybody tell me why we need to add the SQL Server Service Account and IIS Service Account to the "Pre-Windows 2000 Compatible Access Group" in the "Bultin" group of Active Directory? >From all my installation that I did, I added these services because the implementation guide saids to do it. If I don't add these services, everything seems OK to me. no errors or anything. Can anyone tell me why we need these steps? Thanks! DL you are safe to avoid using that group if your system still works fine. "DL" <darrenliu@gmail.com> wrote in messa...

option group?
Well, i'm trying to allow the option group selected display a text field to allow information to be typed in. I need some help on how to go about it. Thanks The values in an Option Group are Integers and they are determined at design time, not run time. You could make a textbox visible in the AfterUpdate event of the OptionGroup. (aircode): Sub grpChoose_AfterUpdate() Select Case grpChoose Case Is 1, 2, 3 Me.txtWhatever.Visible = True Case Is 4 Me.txtWhatever.Visible = False Case Else MsgBox Err.Number & ": " & Err.Description E...

Reference to next record within a group
I am trying to set up a summary query to identify how many total days a patient has gone without any medication. The following are the data that I start with. Member # Fill Date Days Supply Next Med Date 940183753-02 1/11/2007 30 2/10/2007 940183753-02 2/7/2007 30 3/9/2007 940183753-02 2/8/2007 28 3/8/2007 940183753-02 2/11/2007 90 5/12/2007 940183753-02 5/2/2007 90 7/31/2007 940183753-02 5/2/2007 90 7/31/2007 940183753-02 7/12/2007 30 8/11/2007 940183753-02 9/19/2007 30 10/19/2007 940183753-02 9/19/2007 30 10/19/2007 This particular mbr was on multiple meds for a specific di...

Sort by state AND time zone?!
Calling all creative Excel users! I have client phone numbers in an Excel report, and want to somehow link the phone number to its time zone--and then sort the report by time zones! The purpose is to be able to assign outbound calls to staff at different times of the day, depending on time zone we are reaching I'm possibly an advanced beginner in the user of Excel, so don't be afraid to be VERY detailed in your suggestion for a formula! I don't know how to use pivot tables, by the way.. Many thanks Kay Provided you can find a list of area codes/time zones, you could use ano...

Count records b/w time range
I have a sheet which has data with date & time fields like this 19/10/2005 10:10 19/10/2005 11:30 19/10/2005 12:12 19/10/2005 12:15 19/10/2005 10:12 How do I make a formula to pull out count between each half hour slot? like: 10:00 - 10:30 =2 10:30 - 11:00 =0 11:00 - 11:30 =1 11:30 - 12:00 =0 12:00 - 12:30 =2 Please help. Cheers! Sunny =sumproduct(--(B1:B100>--"10:00:00"),--(B1:B100<=--"10:30:00")) -- HTH RP (remove nothere from the email address if mailing direct) <sunilkeswani@gmail.com> wrote in message news:1131569006.191782.216510@g44g200...

Accrue vacation & sick time
I am getting an error message when I try to accrue vacation and sick time in H/R accrue. The message reads - Cannot accrue attendance for a date that isn't within and accrual period. This will be the second payroll for the new year and I did not have any problems for the first payroll for 2010 ...

format group of rows based on condition
I've seen answers to similar problems, but nothing as complex as this: I have the following set-up (simplified) Type City Store actual Portland TB bid Portland TB actual Memphis AU bid Memphis AU bid Memphis AU I need to format in VBA (since this is over 3000 rows deep), in the following manner: Insert a row in between a change in the cities column. Then surround the grouping by city with a bold outline. Color the row with the bid gray and color the rows in between the cities blue. The sheet has...

URGENT: Run Time Error '429' in Store Operations Administrator
I'm constantly getting a run-time error 429 - ActiveX can't create object - when trying to run Store Operations Administrator on my back office PC. The Store Operations Manager also fails on the back office PC - can't connect to database -. The register (POS) is still functioning as is the server where the RMS database resides. How do I fix this? I've never seen Active-X errors from Administrator. I'd try uninstalling RMS on that system then reinstalling it. Also make sure you apply whatever service pack you're running on your other systems. Sometimes POS ...

in Excel how do I copy & paste a grouping as one?
Please use this white space for your question and tell us what you mean by "grouping" best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "DWP" <DWP@discussions.microsoft.com> wrote in message news:3BFCFD66-13E9-44A4-8B2C-3AC4F000E055@microsoft.com... > ...

Formula to say Yes or No based on variance in time cells
Hi all, I have 2 time cells, F5 and I5, I want a forumla that will return the result Yes or No if there is a specified difference, 30mins for example. We have a spreadsheet with the same information coming from 2 sources and need to compare the information to say wether it is similar or not. Thanks in advance for any help Absolute difference? =IF(ABS(F5-I5)>=TIME(0,30,0),"Yes","No") -- HTH Bob Phillips "KingCreole" <shamble@gmail.com> wrote in message news:1117014247.379550.142950@z14g2000cwz.googlegroups.com... > Hi all, > > I have 2 ti...

Formular for Times
Hi Im looking for away to add working hour, that go into the nex day, eg. 22:30 till 07:15. =sum(B1-A1) only seems to work when hours are all in 1 day. Im using excel 2002 Any suggestions would be much appreciated ! Kenn -- Message posted from http://www.ExcelForum.com On Mon, 26 Jul 2004 05:40:00 -0500, Kenno <<Kenno.19zyom@excelforum-nospam.com>> wrote: >Hi >Im looking for away to add working hour, that go into the next >day, eg. 22:30 till 07:15. >=sum(B1-A1) only seems to work when hours are all in 1 day. >Im using excel 2002 > >Any sugges...

Turn off "Show in groups" view in all Inbox folders & subfolders?
I have been searching groups for a way to turn off the show in groups default for all inbox folders and subfolders, and haven't found any solutions other than to turn off each folder separately. Many solutions are offered but they all end up just correcting one file, not all of them. Has anyone come up with a global solution? Thanks! ...