| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change time format from :0 to 0:0 | Excel Worksheet Functions | |||
| convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
| Change number (in text format) to numeric format | Excel Discussion (Misc queries) | |||
| change format for time value | Excel Discussion (Misc queries) | |||
| How do i change numbers in text format to number format? | New Users to Excel | |||
Linear Mode
