View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Enigo Enigo is offline
external usenet poster
 
Posts: 4
Default Convert timespan d:hh:mm:ss to number

Hi,

I have a field that is imported from Siebel to CSV in the format d:hh:mm:ss.
I need to convert this back to seconds. I have tried changing the format of
the cells but this does not work.

Can anyone help?

Thanks