Excel: Insert row for missing date and time

JVanDenP · Dec 20th 2019

My temperatur logger records temperature data every minute, but only saves the data if it differs at least 0,1 °C. To do my calculations in excel I need the data of every minute.

Can I insert the missing minutes somehow? the data file is to large to do it manually and VLOOKUP doesnt work really well with times.

I tried a few VBA codes but none of them worked

Output datalogger: Desired output:

[Blocked Image: https://i.stack.imgur.com/3jJ6e.png] [Blocked Image: https://i.stack.imgur.com/jlod0.png]

**alansidman** · Dec 20th 2019

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

davesexcel · Dec 21st 2019

It's kind of easy to do manually, but hard to explain so I made a clip.

Here's how to do it

Insert Rows between minutes

JVanDenP · Dec 23rd 2019

Quote from davesexcel

It's kind of easy to do manually, but hard to explain so I made a clip.
Here's how to do it
Insert Rows between minutes

Thanks this will work for now!

If anyone wants to try it diffferently i will leave the file in this attachment

davesexcel · Dec 23rd 2019

Right on, nice that you would leave a file after I worked on this.

Excel: Insert row for missing date and time

Participate now!

Share

Tags