Convert minutes data into proper date

[WaqasTariq]

I have a column of data that contains minute values. I am trying to;

1. Convert the minutes into real/proper dates
2. Starting from a Month that I will add to P1, date I add in P2, and year I add to P3.
3. Example data: Minutes_Data.xlsx

This is an idea of what I am trying to achieve.

Raw Data	What I want to achieve				Input
33	01/17/22 12:33 AM			Month:	Jan
43	01/17/22 12:43 AM			Day:	17
45	01/17/22 12:43 AM			Year:	2022
112	01/17/22 1:52 AM
139	01/17/22 2:19 AM
1478	01/18/22 12:38 AM

I am able to convert the minutes how hours and minutes in Excel, but I am struggling to attach them to the correct month/date as I am not sure how to account for months with diffrent days (28, or 30, or 31)

I will appreciate any and all the help.

 

[Fluff]

How about

Minutes_Data.xlsx
	A	B	C									L	M
1	33	17/01/2022 00:33										Month:	Jan
2	43	17/01/2022 00:43										Day:	17
3	45	17/01/2022 00:45										Year:	2022
4	55	17/01/2022 00:55
5	112	17/01/2022 01:52
6	139	17/01/2022 02:19
7	151	17/01/2022 02:31
8	1151	17/01/2022 19:11
9	1457	18/01/2022 00:17
10	1600	18/01/2022 02:40
Sheet1

Cell Formulas
Range	Formula
B1:B10	B1	=DATE($M$3,MONTH("1/"&$M$1),$M$2)+A1/1440

 

[DRSteele]

This might help.

MrExcel posts19.xlsx
	B	C	D	E	F	G
3	Raw Data	What I want to achieve	Achieved			Input
4	33	1/17/2022 0:33	1/17/22 12:33 AM		Month:	1
5	43	1/17/2022 0:43	1/17/22 12:43 AM		Day:	17
6	45	1/17/2022 0:43	1/17/22 12:45 AM		Year:	2022
7	112	1/17/2022 1:52	1/17/22 1:52 AM
8	139	1/17/2022 2:19	1/17/22 2:19 AM
9	1478	1/18/2022 0:38	1/18/22 12:38 AM
Sheet26

Cell Formulas
Range	Formula
D4:D9	D4	=DATE($G$6,$G$4,$G$5)+B4/(60*24)

 

[WaqasTariq]

How about

Thank you, It worked perfectly!

Have a wonderful day!

 

[Fluff]

Glad we could help & thanks for the feedback.