Hi guys!
I have 30-minute interval data for the whole month of April that needs to be converted into 5-minute intervals. Eg. The value in B1 needs to be divided by 6 and put into column F1:F6, and the value in B2 needs to be divided by 6 and put in F7:F12. Is this able to be done in Excel? If so, how? Or is it something that could be done quicker in power query?
I have 30-minute interval data for the whole month of April that needs to be converted into 5-minute intervals. Eg. The value in B1 needs to be divided by 6 and put into column F1:F6, and the value in B2 needs to be divided by 6 and put in F7:F12. Is this able to be done in Excel? If so, how? Or is it something that could be done quicker in power query?
PQ april conversion to 5 min.xlsx | |||
---|---|---|---|
E | |||
5 | 1/04/2023 0:20 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
E5 | E5 | =E4+TIME(0,5,0) |