Converting Timestamp format to seconds

[Bala_s]

Hi Experts,

Need help here!!!

I have one column as AvgTime where i have values like below

1:06:00 AM // This is (hh:mm:ss tt Format)

:51:40   // This is (mm:ss Format)

:11      // This is (ss Format)

I need to present sum(AvgTime) in seconds, how can I convert all above formats to only seconds?

Please help me here to get output.

Regards,

Bala

[sunny_talwar]

Can you check the number's tab of your list box that you are showing? Can you make sure that you have not selected 'Override Document Settings'

[Bala_s]

Hi Sunny,

Yes, 'Override Document Settings' is not selected...

[sunny_talwar]

Would you be able to share a qvw file to show where this isn't working?