Thread: Converting time from text to numeric
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eric Wixom[_2_] Eric Wixom[_2_] is offline
external usenet poster
  
Posts: 4
Default 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 QuoteReply With Quote