PepperBrooks
New Member
- Joined
- Aug 14, 2018
- Messages
- 2
Hi - I am hoping to divide up hourly data into 15-minute increments. The values associated with the hourly data similar should be put into quarters. The two tables below are a small sample example. The first is the data I have now and the second is that data as it should look. I just need the new values. Any ways without a macro are preferable. The final will include data for a full year. Thanks for any help/guidance. Any suggestions?
<tbody>
</tbody>
<tbody>
</tbody>
<tbody> </tbody> |
<tbody>
</tbody>
Hourly Data | Values | 15-Minute Data | New Values |
01/01 01:00:00 | 1 | 1/1/14 12:00:00 AM | .25 |
01/01 02:00:000 | 4 | 1/1/14 12:15:00 AM | .25 |
01/01 03:00:00 | 0 | 1/1/14 12:30:00 AM | .25 |
....cont'd | 1/1/14 12:45:00 AM | .25 | |
1/1/14 1:00:00 AM | 1 | ||
1/1/14 1:15:00 AM | 1 | ||
1/1/14 1:30:00 AM | 1 | ||
1/1/14 1:45:00 AM | 1 | ||
1/1/14 2:00:00 AM | 0 | ||
1/1/14 2:15:00 AM | 0 | ||
1/1/14 2:30:00 AM | 0 | ||
1/1/14 2:45:00 AM | 0 | ||
....cont'd |
<tbody>
</tbody>