Posted to microsoft.public.excel.worksheet.functions

Eric Wixom[_2_] Eric Wixom[_2_] is offline

external usenet poster

Posts: 4

Converting time from text to numeric

I have a column of time logs ranging from:

1:00:00:00
to
0:01

I need to split this into days, hours, minutes, and seconds. They are not
the same length so LEFT or RIGHT functions wont work, and I am not savvy
enough in VB to program the split.

Any suggestions?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Display leading zeros in numeric value without converting to text	Gmonny	Excel Discussion (Misc queries)	4	October 5th 06 09:05 PM
Converting Numeric values to Text	shail	Excel Worksheet Functions	2	September 5th 06 04:50 PM
converting text to numeric data	babooz	Excel Worksheet Functions	3	May 19th 06 08:14 AM
Converting variable text strings to numeric	Richgard53	Excel Discussion (Misc queries)	1	July 13th 05 06:22 AM
Converting Text into a Numeric Value and Totalling	Shazbut	Excel Worksheet Functions	1	May 10th 05 05:14 PM

All times are GMT +1. The time now is 10:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us