Usually in databases durations is stored as an integer if the minimum to store is seconds. Easy to calculate anything from there.
If you need to store partial seconds then use a real. Dan Goldberg From: [email protected] [mailto:[email protected]] On Behalf Of Stephen Markson Sent: Thursday, June 29, 2017 7:44 AM To: [email protected] Subject: RE: [RBASE-L] - Loading hh:mm:ss durations for computation (not the Time of Day) Hi, You can get the duration by subtracting midnight from the imported times. Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of lwilson Sent: June-28-17 10:28 PM To: RBASE-L Cc: [email protected]<mailto:[email protected]> Subject: Re: [RBASE-L] - Loading hh:mm:ss durations for computation (not the Time of Day) Thanks Razzak, Perhaps I misstated. I am confident the the durations times will load in Rbase X. However, they load as a time of day. I need to be able to add the duration for several records to come to a total of a specific duration. Example, I want to determine to total of all Wait Time for a specific Agent for a given week/month. I want to know the active utilization for an Agent for a Specific month. Loading the durations as a Time if day does not give me the ability to sum the durations. I can do it in Excel but I'm dealing with 6k-10k records per month. Hope this clarifies. Thanks again. On Wednesday, June 28, 2017 at 10:14:33 PM UTC-4, A. Razzak Memon wrote: Larry, Welcome back! What is the setting for TIME FORMAT and TIME SEQUENCE after connecting the database? SHOW TIME Make sure that the TIME SEQUENCE is set correctly. The keyword SEQ (sequence) sets the entry sequence such as HHMMSS while the keyword FOR (format) sets the display format. For example, the format HH:MM:SS can display 14:30:20. Looking at your sample Excel file, you should have absolutely no problem importing data into R:BASE XE to perform any Key Performance Indicators, etc. Hope that helps! Razzak At 07:00 PM 6/28/2017, lwilson wrote: >I am a returning Rbase user. Primary use to to >manipulate large amounts of data for analytical purposes for my clients. >My current client operate a crises call center >and has asked me to perform a staffing study. >As such, I need to look at certain metrics and >KPIs to assess utilization and staffing demands, > >The data file I receive is in Excel with a Start >date & time for the call followed by certain KPI >durations that are reported in hh:mm:ss. > >RBase will not allow import of these time >increments, but I need to be able to accumulate >these various durations. Reporting on the >seconds is not critical however, the accumulated >seconds can matters especially in calculating cost per call. > >Help on how to accumulate these duration in >order to provide meaningful analytics would be enormously helpful! > >in addition to the excerpt below, I have also attached a sample Excel file. >Â >Any tips? > >Customer Experience Start Customer Experience >Dur. Customer Contact Direction First Delivery >Routing Point First Delivery Queue Disposition >Wait Dur. Active Dur. On Hold Dur. >Jun 1, 2016 7:11:16 AM 00:05:49 10000000000 >Inbound DMH Crisis Ln 888-793-4357 (4813805) DMH >Crisis (41) Disconnected by Agent 00:00:10 00:05:39 00:00:00 >Jun 1, 2016 7:41:25 AM 00:01:18 20000000000 >Inbound DMH Crisis Ln 888-793-4357 (4813805) DMH >Crisis (41) Party Disconnected 00:00:12 00:00:41 00:00:25 >Jun 1, 2016 8:27:32 AM 00:00:32 30000000000 >Inbound DMH Crisis Ln 888-793-4357 (4813805) DMH >Crisis (41) Party Abandoned Contact 00:00:32 00:00:00 00:00:00 >Jun 1, 2016 9:15:38 AM 00:04:11 40000000000 >Inbound DMH Crisis Ln 888-793-4357 (4813805) DMH >Crisis (41) Disconnected by Agent 00:00:08 00:02:24 00:01:39 >Jun 1, 2016 9:24:45 AM 00:13:46 50000000000 >Inbound DMH Crisis Ln 888-793-4357 (4813805) DMH >Crisis (41) Party Disconnected 00:01:15 00:11:51 00:00:40 >Jun 1, 2016 9:42:15 AM 00:00:43 60000000000 >Inbound DMH Crisis Ln 888-793-4357 (4813805) DMH >Crisis (41) Disconnected by Agent 00:00:09 00:00:34 00:00:00 >Jun 1, 2016 10:28:56 AM 00:04:39 70000000000 >Inbound DMH Crisis Ln 888-793-4357 (4813805) DMH >Crisis (41) Disconnected by Agent 00:00:08 00:04:31 00:00:00 >Jun 1, 2016 10:50:45 AM 00:09:34 80000000000 >Inbound DMH Crisis Ln 888-793-4357 (4813805) DMH >Crisis (41) Disconnected by Agent 00:00:07 00:09:27 00:00:00 >Jun 1, 2016 11:15:46 AM 00:31:01 90000000000 >Inbound DMH Crisis Ln 888-793-4357 (4813805) DMH >Crisis (41) Party Disconnected 00:00:33 00:27:57 00:02:48 >Jun 1, 2016 11:24:32 AM 00:10:02 11000000000 >Inbound DMH Crisis Ln 888-793-4357 (4813805) DMH >Crisis (41) Party Disconnected 00:00:13 00:04:54 00:04:55 > >-- >You received this message because you are >subscribed to the Google Groups "RBASE-L" group. >To unsubscribe from this group and stop >receiving emails from it, send an email to >[email protected]<javascript:>. >For more options, visit https://groups.google.com/d/optout. >Content-Type: >application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; > name="Sample Test Data file.xlsx" >Content-Disposition: attachment; filename="Sample Test Data file.xlsx" >X-Attachment-Id: abb07988-c209-4052-857e-df062bb2dca4 >Content-ID: <abb07988-c209-4052-857e-df062bb2dca4> -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
