• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Time Difference

sambit

Member
Sir,
Please help to resolve the following issue.

Expected Result look like below
Start TimeEnd TimeDifference Time(HH:MM:SS)
20-4-2021 10:20 AM​
20-4-2021 10:50 AM​
0:30:00
20-4-2021 3:00 PM​
20-4-2021 8:00 PM​
5:00:00
20-4-2021 9:00 AM​
20-4-2021 3:00 PM​
6:00:00
20-4-2021 7:00 AM​
21-4-2021 7:00 AM​
24:00:00
20-4-2021 7:00 AM​
21-4-2021 7:10 AM​
24:10:00
20-4-2021 7:00 AM​
22-4-2021 7:15 AM​
48:15:00
 

Attachments

  • Example-1.xlsx
    9.6 KB · Views: 1
sambit
What was Your point?
= End Time - Start Time
and format output as You would like to get...
 

Attachments

  • Example-1.xlsx
    10.3 KB · Views: 6
Back
Top