How to convert Hourly data to 5mins data

[jianroy]

Hello,

Good day

Would like to ask how to convert below data.

Thank you and God Bless!

		689,000.00		0​
06/26/2022​	1	19,000.00	26/06/2022 0:05​	?
06/26/2022​	2	10,000.00	26/06/2022 0:10​	?
06/26/2022​	3	30,000.00	26/06/2022 0:15​	?
06/26/2022​	4	30,000.00	26/06/2022 0:20​	?
06/26/2022​	5	30,000.00	26/06/2022 0:25​	?
06/26/2022​	6	30,000.00	26/06/2022 0:30​	?
06/26/2022​	7	30,000.00	26/06/2022 0:35​	?
06/26/2022​	8	30,000.00	26/06/2022 0:40​	?
06/26/2022​	9	30,000.00	26/06/2022 0:45​	?
06/26/2022​	10	30,000.00	26/06/2022 0:50​	?
06/26/2022​	11	30,000.00	26/06/2022 0:55​	?
06/26/2022​	12	30,000.00	26/06/2022 1:00​	?
06/26/2022​	13	30,000.00	26/06/2022 1:05​	?
06/26/2022​	14	30,000.00	26/06/2022 1:10​	?
06/26/2022​	15	30,000.00	26/06/2022 1:15​	?
06/26/2022​	16	30,000.00	26/06/2022 1:20​	?
06/26/2022​	17	30,000.00	26/06/2022 1:25​	?
06/26/2022​	18	30,000.00	26/06/2022 1:30​	?
06/26/2022​	19	30,000.00	26/06/2022 1:35​	?
06/26/2022​	20	30,000.00	26/06/2022 1:40​	?
06/26/2022​	21	30,000.00	26/06/2022 1:45​	?
06/26/2022​	22	30,000.00	26/06/2022 1:50​	?
06/26/2022​	23	30,000.00	26/06/2022 1:55​	?
06/26/2022​	24	30,000.00	26/06/2022 2:00​	?
			26/06/2022 2:05​	?
			26/06/2022 2:10​	?
			26/06/2022 2:15​	?
			26/06/2022 2:20​	?
			26/06/2022 2:25​	?
			26/06/2022 2:30​	?
			26/06/2022 2:35​	?
			26/06/2022 2:40​	?
			26/06/2022 2:45​	?
			26/06/2022 2:50​	?
			26/06/2022 2:55​	?
			26/06/2022 3:00​	?
			26/06/2022 3:05​	?
			26/06/2022 3:10​	?
			26/06/2022 3:15​	?
			26/06/2022 3:20​	?
			26/06/2022 3:25​	?
			26/06/2022 3:30​	?
			26/06/2022 3:35​	?
			26/06/2022 3:40​	?
			26/06/2022 3:45​	?
			26/06/2022 3:50​	?
			26/06/2022 3:55​	?
			26/06/2022 4:00​	?
			26/06/2022 4:05​	?
			26/06/2022 4:10​	?
			26/06/2022 4:15​	?
			26/06/2022 4:20​	?
			26/06/2022 4:25​	?

 

[jianroy]

Sorry, below should be data.

		449,000.00		22333.33333​
06/26/2022​	1	19,000.00	26/06/2022 0:05​	1,583.33
06/26/2022​	2	10,000.00	26/06/2022 0:10​	1,583.33
06/26/2022​	3	30,000.00	26/06/2022 0:15​	1,583.33
06/26/2022​	4	30,000.00	26/06/2022 0:20​	1,583.33
06/26/2022​	5	30,000.00	26/06/2022 0:25​	1,583.33
06/26/2022​	6	30,000.00	26/06/2022 0:30​	1,583.33
06/26/2022​	7	30,000.00	26/06/2022 0:35​	1,583.33
06/26/2022​	8	30,000.00	26/06/2022 0:40​	1,583.33
06/26/2022​	9	30,000.00	26/06/2022 0:45​	1,583.33
06/26/2022​	10	30,000.00	26/06/2022 0:50​	1,583.33
06/26/2022​	11	30,000.00	26/06/2022 0:55​	1,583.33
06/26/2022​	12	30,000.00	26/06/2022 1:00​	1,583.33
06/26/2022​	13	30,000.00	26/06/2022 1:05​	833.3333333
06/26/2022​	14	30,000.00	26/06/2022 1:10​	833.3333333
06/26/2022​	15	30,000.00	26/06/2022 1:15​	833.3333333
06/26/2022​	16	30,000.00	26/06/2022 1:20​	833.3333333

 

[bebo021999]

Is it?

Book1
	A	B	C	D	E
1			449,000.00		22,333.33
2	26-Jun	1	19,000.00	26-Jun 00:05	1,583.33
3	26-Jun	2	10,000.00	26-Jun 00:10	1,583.33
4	26-Jun	3	30,000.00	26-Jun 00:15	1,583.33
5	26-Jun	4	30,000.00	26-Jun 00:20	1,583.33
6	26-Jun	5	30,000.00	26-Jun 00:25	1,583.33
7	26-Jun	6	30,000.00	26-Jun 00:30	1,583.33
8	26-Jun	7	30,000.00	26-Jun 00:35	1,583.33
9	26-Jun	8	30,000.00	26-Jun 00:40	1,583.33
10	26-Jun	9	30,000.00	26-Jun 00:45	1,583.33
11	26-Jun	10	30,000.00	26-Jun 00:50	1,583.33
12	26-Jun	11	30,000.00	26-Jun 00:55	1,583.33
13	26-Jun	12	30,000.00	26-Jun 01:00	1,583.33
14	26-Jun	13	30,000.00	26-Jun 01:05	833.33
15	26-Jun	14	30,000.00	26-Jun 01:10	833.33
16	26-Jun	15	30,000.00	26-Jun 01:15	833.33
17	26-Jun	16	30,000.00	26-Jun 01:20	833.33
Sheet2

Cell Formulas
Range	Formula
C1,E1	C1	=SUM(C2:C17)
D2:D17	D2	=$A$2+(INDEX($B$2:$B$17,INT((ROWS($1:1)-1)/12)+1)-1)/24+(MOD(ROWS($1:1)-1,12)+1)*5/1440
E2:E17	E2	=INDEX($C$2:$C$17,INT((ROWS($1:1)-1)/12)+1)/12

 

[jianroy]

Thanks a lot How about if its hourly to 15mins?

 

[bebo021999]

Thanks a lot How about if its hourly to 15mins?

Search "5" in formula and change to 15

 

[jianroy]

Thank you very much

 

[jianroy]

Thank you very much

Hello, What do i do if the dates will be June 26, 2022 up to July 25, 2022?