Same question, asked in a new package -
http://www.sqlservercentral.com/Forums/FindPost585845.aspx
and
http://www.sqlservercentral.com/Forums/FindPost585851.aspx
No matter what you do with these - you will need to convert them first, then do whatever math you need to do.
You REALLY should keep these all together, since they are so closely related. You give the impression you're not reading the answers you're being given.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?