troubleshooting Question

Bad Date-Time Format

Avatar of Marcus Aurelius
Marcus AureliusFlag for United States of America asked on
Crystal Reports
4 Comments2 Solutions929 ViewsLast Modified:
Experts:

I need help calculating AVERAGE TIME. I have a field that holds a CALL_DURATION of a telephone call in this format:

CALL_DURATION
---------------------
00:14
00:20
00:05
145:14
100:10
60:15

When I try to use this formula I get the error:   BAD DATE-TIME FORMAT STRING

//@CallDurationToSeconds
(
(hour(datetime({View_smdrdata_Phone_System.CallDuration})) * 60 * 60 ) +
(minute(datetime({View_smdrdata_Phone_System.CallDuration})) * 60)
+ (second(datetime({View_smdrdata_Phone_System.CallDuration})))
) /60


This is the portion that is CR highlights as being a problem:

datetime({View_smdrdata_Phone_System.CallDuration})

I've tried different things...but I can't seem to get it....your help is appreciated.

MikeV
ASKER CERTIFIED SOLUTION
dsacker
Contract ERP Admin/Consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros