Thread: Converting Time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DaveM[_2_] DaveM[_2_] is offline
external usenet poster
 
Posts: 77
Default Converting Time

Hi


Using excel 2007

I have Column A which has cells with lots of times in them.

01.0.14
01.2.24
59.55
57.01

Min.Sec.MilliSeconds
Formatted as General

I need to work with these so I can Add, Subtract, Etc.

I've tried formatting as mm:ss.00 and using text to columns, etc. With no
joy


Hope someone can help


DaveM