Hi Siva, What you will want to do is enter your time in Excel like this 00:18:15 with the custom format mm:ss. In the cell where you want to calculate seconds enter =DataCell*86400 and format the cell as a number not time. If everything is working correctly you should end up with 1095 seconds. Let me know if you run into any trouble.

No problem Erana, Glad I could help.

lol... didn\'t you tell me about this...

No problem. I'm glad I could help. I know how frustrating it can be when you "think" you know what you want, but for what ever reason you just can't find it.