Hi, I am creating a PowerShell script to append data to a certain range of cells in an .xls worksheet. The existing cell data are numbers IE:1234 and I need to append /60 to the end of each which converts seconds to minutes. This is what I have so far and I cannot seem to get passed this. Ideas?
Here is the error I get:
Cannot convert value "/60" to type "System.Double". Error: "Input string was not in a correct format."
At line:8 char:2
+ $Cell.Value2 += ($DataType)
+ CategoryInfo : InvalidArgument: (:) , RuntimeException
+ FullyQualifiedErrorId : InvalidCastFromStringToDoubleOrSingle