Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting Times
Hi
I've been trying to change these, yet can't figure how to do it The column is formatted in General 59.22s to 00.59.22 1m 31.58s to 01.31.58 Thanks in advance Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting Times
On Aug 18, 11:48*am, "Dave" wrote:
Hi I've been trying to change these, yet can't figure how to do it The column is formatted in General 59.22s * * * * * to * *00.59.22 1m 31.58s * * *to * *01.31.58 Thanks in advance Dave Dave, Take a look at the Format Cells Dialog (Ctrl + 1). In the "Number" tab you'll see "Time" under the category. Look through this to get an idea you how you can format your number as time. If you don't find something you like within the "Time" category then go to "Custom" and create your own. If your cell is a text string (i.e. it truly states 59.22s - numbers and text), then this will be a different issue because you'll need to transform your data a bit before you can get it to the desired format (which won't be difficult because Excel's built in formulas make that pretty easy; however, if you want to do math on the cells then that's yet again a separate issue). Best, Matthew Herbert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Times | Excel Worksheet Functions | |||
Converting military times to numbers | Excel Programming | |||
Help: Converting Pluses and Times to Sum and Product Functions ??? | Excel Programming | |||
converting times | Excel Programming | |||
Converting Times | Excel Programming |