Thank Rick, good idea to combine all three into a single pattern.

=REGEXEXTRACT(A3:.A500,{“\d+”,”[A-Z][a-z].+”,”[A-Z]{2}”},1)

https://www.linkedin.com/pulse/vertical-gantt-chart-mochamad-aris-zamroni/

That can be found in data validation…in the ‘Input Message’ tab.

Thanks Kris !

Thanks Meganathan !

List.Transform(
Table.Split( Excel.CurrentWorkbook(){[Name=”Table1″]}[Content],3) ,
// Split Table1 into chunks of 3 rows each, then transform each chunk

each [
a = Table.ToRows(_) ,
// Convert this 3-row mini-table into a list of row-lists (“a”)

b = (v)=> Number.From( a{v}{0}) + a{v}{1},
// Define a custom function “b” that:
// – takes a row index v
// – converts the first column to number
// – adds it to the second column

c = {
a{0}{0}, // First column, first row → becomes the “Name”
(b(2) – b (1)) * 24 // Difference between row 2 and row 1 via “b”, scaled by 24 → “Duration”
}
] [c]
// Take only c out of that record (discard a and b), return as a list
)
)