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")
Comments
Post a Comment