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