Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
G'day All,
I'm very rusty with VBA. I'm trying to convert text "1:28.871" to time "m:ss.000" I've got: Sub TEXT_TO_TIME() For Each cell In ActiveRange cell.Value = TimeValue(cell) Next cell End Sub This gives me "run-time error '13':" A google points to "due to copied data being formatted as text rather than numbers" but hey I know that. Any Ideas? Thanks in anticipation, build |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I convert time as text 'mm:ss to time value in Excel | Excel Discussion (Misc queries) | |||
Macro / function text time to 24hr excel time passed midnight fortotaling hr's | Excel Worksheet Functions | |||
Convert Text Time to Excel Time | Excel Discussion (Misc queries) | |||
convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
Convert Text Time to Time | Excel Discussion (Misc queries) |