The database field field is formatted HH:MM. Techs enter their time in this format. Multiple entries can be made per CallID (PK).

 

When I group on CallID, I see all of the time entries. Example

 

Total Time

01:45

00:37

02:15

 

I want to add all of these times together to get a grand total of time spent per CallID.

 

When I attempt to summarize (looking for sum) on this field, I do not have any math summaries. All are text (Count, Max, etc...). I believe that is because this is a text field.

 

What can I do to format this field so that I can calculate the accumulative time? I'm assuming a formula will do it, but I can't seem to find the right formula or function that will convert this field into something that I can calculate.

 

Thank you!

 

 

 

 

 

I'm not sure what is happening with converting it back.

 

I created a second formula as follows:

 

dateadd('n',Sum ({@ToNumber}, {CallLog.CallID})),datetime(1900,1,1,0,0,0))

 

but I get an error "The remaining text does not appear to be part of the formula" - this is referring to datetime and the remaining text to right.

 

What am I missing?

 

Thanks so much.