View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carl Carl is offline
external usenet poster
 
Posts: 361
Default Reformat A Time Value To Add/Subtract

My Time Values come in like this :

80814240354


I need to work with the last 8 characters. In this case 14240354 - which is
a time "XX:XX:XX:XX" (hours:minutes:seconds:milliseconds).

I need to be able to add and subtract inorder to measure the time
differences.

Is this possible.

Thank you in advance.