Simple Excel Tip – To calculate difference between two time Slots

Share Now


 

A month back, my colleague Mayank Sharma ( Heavy build – Super hero :)) asked me a question “How to calculate difference between two time slots in a standard time format”.  So today I want to introduce a simple excel tip “How to calculate difference between two time slot”.

Let’s Say you want to find out how long an employee take to complete his/her project. There are many ways to calculate difference between time slots. One of them which I mostly use, Here it is.

1)  To Calculate difference in standard time format.

Suppose a project Start Time is 6/11/2012 10:45 AM and End Time is 6/11/2012 5:30 PM.

Write Formula “=Text(B1-A1,”h:mm:ss”)”        ( In this formula Start time is in Cell A1 and End time is in cell B1 of your excel worksheet)

 

 

 

2)       To calculate result as a total of hours, minutes or seconds:

Example:  Start time (Cell A3) = 6/11/2012 10:45 AM and End time (Cell B3) = 6/25/2012 5:30 PM

a). To get the total hours between the two times write this formula:

=INT((B1-A1)*24). The result is 342.

b). To get the total minutes between the two times write this formula:

=INT((B1-A1)*1440). The result is 20565.

c). To get the total seconds between the two times write this formula:

=INT((B1-A1)*86400). The result is 1233900.



Share Now
November 16, 2019

0 responses on "Simple Excel Tip - To calculate difference between two time Slots"

    Leave a Message

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

    EC Analytics will help your business make better decisions by providing expert-level business intelligence (BI) services. Forecasting, strategy, optimization, performance analysis, trend analysis, customer analysis, budget planning, financial reporting and more. EC Analytics also offers Advanced Data Analytics training in corporate and retail.

    Social Media

    ECAnalytics-facebookECAnalytics_Linkedin

    Address:

    NM 23, SECTOR 14, OLD DLF COLONY,
    GURGAON (HARYANA)
    0124- 4601426

    EC Analytics Consulting @ 2019 ALL RIGHTS RESERVED