Hello readers ! Today we are going to learn how to find difference between two date times using MS Excel that can be useful for finding the working hours of employee. Let us follow below steps for it.
Open a new excel file in MS Excel 2007.
Make two columns with names – start time and end time with value as shown below image .
Select date time in start time column (B2) . Click on format cell by Right clicking as shown below image.
Step 4 .
A dialog box will be appeared . Choose date format in mm/dd/yy HH:mm as shown below.
Change the format of end time column as you did in step 3 & 4.
Click on D2 cell. Subtract b2 cell from c2 cell by using the formula =(C2-B2)
select the cell the D2 . Go to format cell by right clicking .
Click on Number tab . Choose the custom option from category and choose the format – [h]:mm:ss as shown below image.
Now ,Congratulations ! you got differences between two date time.
Hope this tutorial will help you to learn an interesting lesson in Ms Excel.