Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strings to Numbers
I have an Excel spreadsheet that I import into Access. On the Access side I
have 2 fields, Duration it looks like this 0:13:25, Duration1, that I want to look like this, 13:25 where I can do some math. Is this possible? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strings to Numbers
In order for someone to answer the question you
have to indicate what the number represents as seen. For lack of such information I will assume for now that it represents hours:minutes:seconds and all you need to do is format at [mm]:ss to show minutes and seconds where minutes does not overflow into hours. If the field is text and you need to convert it to a number then you can use the TrimALL macro as seen at http://www.mvps.org/dmcritchie/excel/join.htm#trimall --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "open a adobe file from a command button" osoft.com wrote in message ... I have an Excel spreadsheet that I import into Access. On the Access side I have 2 fields, "Duration" it looks like this 0:13:25, "Duration1", that I want to look like this, 13:25 where I can do some math. Is this possible? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help With Searching For Strings In Part Numbers | Excel Worksheet Functions | |||
Combine strings and numbers | Excel Discussion (Misc queries) | |||
Extracting numbers from alphanumeric strings | Excel Worksheet Functions | |||
Strings and numbers in cells | Excel Discussion (Misc queries) | |||
Extract numbers from strings | Excel Worksheet Functions |