Most valuable professional
  • Hot Topics

Excel Convert a string into date - hour

Hey guys, I need some help. I have 2 separated cells with these STRINGS, indicating date and hours: Apr-14-14 00:31:41 Apr-15-14 00:29:41 I would like to calculate, in a third cell, the difference between the 2 date/hours (in seconds). How can I convert these 2 string cells into a date + hour format, so that I can compute the difference? My version of Excel is 2013. Thank you.

This question generated 22 answers. To proceed to the answers, click here.

This thread is current as of April 16, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel