Hi Community,



I'm uploading Historic data...in which I've a Embedded field named as "Waiting_time" which records the time a customer was waiting until s/he was served by a customer care representative. The time is stored in the below format...



0:12:56

0:00:22

0:04:28

0:01:30

0:32:52

0:00:10

0:07:46

0:03:08

1:04:58





What should be the Field Type of this Embedded data field so that I can calculate the average wait time?



Thanks,

Abdul