Can I create 15 minute data from an hourly dataset?

[MF2680]

Hi. This is my first post, and I’m a long-term excel user, but only for basic tasks – I’m still a novice!
My problem is this:

I have a sheet with 2 columns: date/hour and water level. I need to insert these columns into a programme which will help me calculate streamflow. Unfortunately, it needs the data in 15 minute intervals.

I am happy to use the hourly data to ‘fill’ the 15 minute gaps, but this doesn’t seem to be intuitive!

I have created a new column with day date in 15 minute intervals, & the first 2 hours data and hoped to be able to drag down the column to create my new 15 minute dataset. Unfortunately, as people on this forum probably realised at the start, excel doesn’t work this way!

Is there any way of doing this? Feel free to ask for clarification if I haven’t explained very well!

Cheers,

Jon

[Pete_UK]

If you attach a sample workbook you can expect to get an answer sooner and customised to your data layout. The FAQ describes how to.

Pete

[Glenn Kennedy]

Attach a sample workbook. 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.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[MF2680]

Thanks for the quick responses. Here's a sample sheet (attached).

Cheers,

Jon

[Glenn Kennedy]

Hi there. try this out.

[Pete_UK]

Put this formula in D4, format as a date/time (as in A), then copy down:

=INDEX(A$4:A$23,INT((ROWS($1:1)-1)/4)+1)+MOD(ROWS($1:1)-1,4)/4/24

Then put this formula in E4:

=VLOOKUP(D4,$A$4:$B$23,2)

and copy that down.

Hope this helps.

Pete

[MF2680]

Glenn,

Many thanks! - I thought there must be a way. I'll look over your formula to try to learn something new today!

Cheers again,

Jon

[MF2680]

Pete,

You too! Looks like there's more than one way to skin a cat - as ever.

Cheers,

Jon

[Glenn Kennedy]

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.