change text format to time
 

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.

change text format to time
 

Just change the formatting after you made the replacement to

[hh]:mm:ss


--

Regards,

Peo Sjoblom






"Hans" wrote in message
...
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.

change text format to time
 

If your time is in hours minutes and seconds, insert it as 117:23:55 (or use
find and replace to change your full stops to colons).

For times beyond 24 hours, the format for display needs to be changed to
[h]:mm:ss. The formula bar will probably show it as a date and time
combination, but that's just the way Excel stores dates & times, and you can
format the cell to display to suit your requirements.
--
David Biddulph

"Hans" wrote in message
...
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.

change text format to time
 

Thanks for help. Seems to be working.

"David Biddulph" wrote:

If your time is in hours minutes and seconds, insert it as 117:23:55 (or use
find and replace to change your full stops to colons).

For times beyond 24 hours, the format for display needs to be changed to
[h]:mm:ss. The formula bar will probably show it as a date and time
combination, but that's just the way Excel stores dates & times, and you can
format the cell to display to suit your requirements.
--
David Biddulph

"Hans" wrote in message
...
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.