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 *

    Social Media

    facebook page EC Analytics Consulting   Linkedin Page EC Analytics Consulting   Youtube EC Analytics Consulting

    Address:

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

    ABOUT EC ANALYTICS CONSULTING

    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.

    EC Analytics Consulting @ 2019 ALL RIGHTS RESERVED