Reformat A Time Value To Add/Subtract

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=TIME(MID(A1,4,2),MID(A1,6,2),MID(A1,8,2))+RIGHT(A1,3)/24/60/60/1000
Format custom as hh:mm:ss.000

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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.
 
Back
Top