Select Kolom A en Format Cell as Text
Enter the following values in colun A in Microsoft Excel
A1 "2008-02-11 09:45:12.023"
A2 "2008-02-11 10:20:12.323"
Select Kolom B en Format Cell as TIME 37:30:55
Enter the following formula in cell B2
=(LEFT(RIGHT(A2;12);8))-(LEFT(RIGHT(A1;12);8))

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.