Format to Subtract Time help

[rockchalk33]

This is the data entry that I have is seen below:

2016.12.28T19:35:08.7235972Z

<tbody>
</tbody>

2016.12.28T19:34:57.7349678Z

<tbody>
</tbody>

Inside there is a "T" and following the "T" is a specific time. I need to get the difference in time between the two pieces of input. Thus in the above example it would be 19:35:08 - 19:34:57 for a total time of 11 seconds.

How can I use Excel to find the Time data in a string similar to those above and subtract it from one another?

Thanks!

 

[godsaaint]

try this:

=TEXT(MID(A1,SEARCH("T",A1)+1,8)-MID(A2,SEARCH("T",A2)+1,8),"HH:MM:SS")

 

[rockchalk33]

try this:

=TEXT(MID(A1,SEARCH("T",A1)+1,8)-MID(A2,SEARCH("T",A2)+1,8),"HH:MM:SS")

Awesome!! Now my issue is summing up those differences, the value I receive looks like this "00:00:11" how to I add that to something like "00:00:35"? Thanks

 

[godsaaint]

Awesome!! Now my issue is summing up those differences, the value I receive looks like this "00:00:11" how to I add that to something like "00:00:35"? Thanks

try: =TEXT(B4+B5,"hh:mm:ss")

Changing B4 and B5 to the real cells you want to sum.