J
Joe
We have a process monitoring system that reports results
in the format of hr:mm:sec (ie. 543:34:41 which is 543
hours, 34 minutes and 41 seconds). When I import the data
into Excel 2000, it is recognized as text and I can't
manipulate the data for statistical analysis. The same is
true when the data is imported into Minitab (statistical
software). Are there any "tricks" that I could use to
manipulate this time format into a format such as 543.34.
This would facilitate statistical manipulation of this
data. Appreciate the help and advice.
Regards,
Joe
in the format of hr:mm:sec (ie. 543:34:41 which is 543
hours, 34 minutes and 41 seconds). When I import the data
into Excel 2000, it is recognized as text and I can't
manipulate the data for statistical analysis. The same is
true when the data is imported into Minitab (statistical
software). Are there any "tricks" that I could use to
manipulate this time format into a format such as 543.34.
This would facilitate statistical manipulation of this
data. Appreciate the help and advice.
Regards,
Joe