Subtracting two Timestamps in Excel

 

Problem:

We have two timestamps. Need to calculate the time difference.

Issues:

• It might be only Time (same day)
• It can be Days and Hours.

Approach:

• Split Date
• Split Time
• Find Date Difference
• Find Time Difference

=SPLIT(F4," ")

Final Formula:

=CONCATENATE(V4-T4," days ",hour(W4-U4)," hours ",MINUTE(W4-U4)," minutes")