Most valuable professional
  • Hot Topics

Excel Date / time spacing

Hi - I have numerous historic data files - all are date & time stamped in a single column. All data is at five minute intervals over a ten week period. The data is in contiguous rows - there are no gaps; but sporadically the data is not contiguous - individual or strings of time stamps are absent, and different files may have different gaps! Please - is there a method whereby Excel can sort the data such that blank rows are inserted for the missing time stamps? - such would enable me to align all the files for rapid comparison. Thank you.

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

This thread is current as of May 14, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel