Posts

Showing posts from March 25, 2019

How to compare time between 2 columns in Excel

Image
0 I have 2 columns of date in my Excel spreadsheet, and I want to calculate the time (in sec) between the 2 dates. Time Time1 2017-08-22 19:45:22.2327928 2017-08-22 19:45:20.9915171 2017-08-22 19:45:40.3645187 2017-08-22 19:45:21.4451237 2017-08-22 19:45:25.2337426 2017-08-22 19:45:24.3347192 2017-08-22 19:45:20.8958264 2017-08-22 19:45:27.1250265 2017-08-22 19:45:29.5987311 2017-08-22 19:45:27.9014672 I went thru this article, and I tried using these formulas: =TEXT(D2-B2, "hh:mm:ss") =TEXT(D2-B2, "yyyy-mm-dd hh:mm:ss") But none of them works. Can you please tell me how can I get the time difference between 2 dates in Excel? microsoft-excel date-time ...