22 May, 2009
Roel van Lisdonk
0 Comments
0 categories
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))
Tags: Excel
Related Posts
An error has occurred during report processing. Login failed for user '(null)'
22 May, 2009
Roel van Lisdonk
0 Comments
0 categories
The error An error has occurred during report processing. Login…
AngularJS and Breeze – A simple crud app – Part 2 – Adding create, delete, reset and is dirty checking.
11 July, 2014
Roel van Lisdonk
0 Comments
1 category
In my previous post I created a simple [AngularJS…
How to search in all you’re Microsoft Office Outlook 2010 folders and accounts at the same time (Hotmail, Exchange etc.)
7 July, 2010
Roel van Lisdonk
0 Comments
1 category
In my daily work I use two mailboxes: A Microsoft…