Skip to Content
0
Apr 12, 2010 at 01:21 PM

change one field type to time field within a formula

29 Views

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