I have data showing time as xx.xx.xx( i.e. 117.23.55). I would like to count
spent hours, but the format of the data needs to be changed. Replacing the
fullstop by a colon works for some cells, but some cells turn out showing a
date and another time. Any ideas how to change the format of the data?
I am using excel 2003.