change text format to time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Thanks for help. Seems to be working.

David Biddulph said:
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 said:
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.
Click to expand...
Click to expand...
 
Back
Top