Calculating more than 24 hours

K

KP

I have a table with 3 fields Name, Date, and Call
Duration. The Call Duration column is in hh:nn:ss
format. In my report I want to sum the Call Duration
column to give me a total per person. The problem I have
is if their total Call Duration is more than 24 hours the
numbers are wrong. See example below.

Name Date CallDuration
Mike 10/22 10:30:15
Dave 10/22 22:15:30
Mike 10/22 17:15:15
Dave 10/22 01:15:15

When I sum this I Get:
Name Date CallDuration
Mike 10/22 3:45:30
Dave 10/22 23:30:45

What I want to get is:
Name Date CallDuration
Mike 10/22 27:45:30
Dave 10/22 23:30:45

Can anyone help???????? I have read all the KB articles
on Clocking in and out time calcs but this is different
b/c it is one column. Those articles are of no help that
I can see. If I am wrong please explain!

Thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top