Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Using DateDiff to calculate time of a phone call

Posted on 2003-03-10
5
Medium Priority
?
456 Views
Last Modified: 2012-05-04
I want to calculate the time spent on each call, I believe i can use datediff formula, but where it asks for interval type, i dont know what they want..
0
Comment
Question by:it_lite
  • 3
  • 2
5 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 500 total points
ID: 8103133
Interval is a character to request time in days, months, etc

"d" for days
"m" for months
"h" for hours
"n" for minutes

You get a decimal number returned

Datediff ("d", {StartDate},{EndDate})
1.5 means 1.5 days

mlmcc
0
 

Author Comment

by:it_lite
ID: 8103206
Thanks alot, is there one for seconds, that is what i will be dealing with mostly.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 8104697
Yes.  I think it is "s"

mlmcc
0
 

Author Comment

by:it_lite
ID: 8104720
Thanks again, I tried "s" before you replied and it worked, I wish I had some points to give you for that...
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 8106946
No problem.

By the way use "yyyy" for years "y" for some reason does days.

mlmcc
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses
Course of the Month14 days, 16 hours left to enroll

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question