View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dhg4 dhg4 is offline
external usenet poster
 
Posts: 2
Default Milliseconds in Excel

Can Excel handle milliseconds? Or is the only way to do it as a string?
The code below chokes on cDate(full_time)

full_time = Format(hr, "00") & ":" & Format(mn, "00") & ":" &
Format(sc, "00")
full_time = full_time & "." & Format(ml, "000")
Worksheets(2).Cells(ind, 1) = cDate(full_time)