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

Popular posts from this blog

Sony SRS D8

Garbage Bin : A New Creative Hit

SMS Limit Busted, Freedom Regained!