I am basically hard coding some data depending on what the field csr_phones.Call Type equals however they all are numbers except one is a time field (Wrap Up Time) last one in the formula. How do I change the one type to a time within my same formula which is like this:
If {csr_phones.Call Type} = "Inbound"
then
1508
else
If {csr_phones.Call Type} = "Outbound"
then
634
else
If {csr_phones.Call Type} = "Hold"
then
263
else
If {csr_phones.Call Type} = "ACD Ring On"
then
104
else
If {csr_phones.Call Type} = "Wrap Up Time"
then
7:51:46
Any help appreciated.
thanks