Hello readers ! Today we are going to learn how to find difference between two date time into hour, minutes and seconds using MSExcel tricks that can be useful for finding the working hours of employee. Let us follow below steps for it. While managing and analyzing data, it is common task that you may need to perform is finding the difference between two date and time values and expressing the result in hours, minutes, and seconds. This can be useful for calculating the duration of a project, tracking the time spent on a task, or measuring the performance of a process. In this article, we’ll explore how to find the difference between two date and time values in MS Excel and convert the result into hours, minutes, and seconds using various Excel functions and formulas.
Step 1.
Open a new excel file in MS Excel 2007.
Step 2.
Make two columns with names – start time and end time with value as shown below image .
Step 3.
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.
.
Step 5.
Change the format of end time column as you did in step 3 & 4.
Step 6.
Click on D2 cell. Subtract b2 cell from c2 cell by using the formula =(C2-B2)
Step 7.
select the cell the D2 . Go to format cell by right clicking .
Step 8.
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.
In conclusion, calculating the difference between two date and time values and expressing the result in hours, minutes, and seconds can be a valuable skill for anyone working with data in MS Excel. By using the various functions and formulas available in Excel, you can quickly and easily perform this task and gain insights into the performance of your projects, tasks, or processes. With the step-by-step instructions and practical examples provided in this article, you’ll be well-equipped to use Excel to calculate the duration of any project or task and impress your colleagues and boss with your proficiency in Excel.
Please Check out our playlist to know about some advanced tricks about excel/google sheet and also check our another tutorial.