| 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. |
| 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 | |||
Threaded Mode
