Posts

Showing posts from May, 2021

Subtracting two Timestamps in Excel

Image
  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" )