Sorry, no didn’t explain very well.
It’s 3 columns Date, time, value.
Every day from 01/01 to 31/12 and time every 5 minutes from 00:00 to 23:55, each with a value.
I need to add the extra minutes into the minute column and calculate the value
I.E.
Date Time Value
01/01/2018 00:00 1.1
01/01/2018 00:05 1.5
01/01/2018 00:10 1.9
and I need to get to
Date Time Value
01/01/2018 00:00 1.1
01/01/2018 00:01 x.x
01/01/2018 00:02 x.x
01/01/2018 00:03 x.x
01/01/2018 00:04 x.x
01/01/2018 00:05 1.5
01/01/2018 00:06 x.x
01/01/2018 00:07 x.x
01/01/2018 00:08 x.x
01/01/2018 00:09 x.x
01/01/2018 00:10 1.9
etc
EDIT: It’s not for me, trying to do a favour for a mate, and yeah I appreciate excel isn’t the best tool for this, but it’s all that’s available to him.