Cells marked to correlate time in column

[2068Rod]

I am wanting the cells marked X to correlate with the time in the marked column, i then want to be able to calculate the difference between multiple x's marked in a single row.
These are delivery drivers, wanting to work out how many loads a day, time between loads, then finally average time between loads.

Hope this makes sense, very new to this.
Appreciate your help.

 

[Kaper]

As you are using Microsoft 365 the natural way will be by Power Query.
Write somethiung like "Driver" or "Reg. plate" in upper-left corner. Select all your table (starting with times row (not the one above containing just word time).
In Table Design uncheck Filter button
Then Data->Get & Transform Data -> From Table/Range will open PQ editor with your data loaded in. Column with Drivers shall be selected already so do: Transform->Unpivot Columns (note that you shall Click on small triangle to show options)->Unpivot Other Columns
Click on ABC123 icon next to Attributes column and select time
(you may right click on value column (x only values) and delete it)
Close and load your data.

If you are interested in it) the code of query which has been recordes shall look like:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Driver"}, "Attribute", "Value"),
    #"Changed Type" = Table.TransformColumnTypes(#"Unpivoted Other Columns",{{"Attribute", type time}})
in
    #"Changed Type"

If new x's are added or removed to your table or drivers list change, right click on the output table you received and select Refresh from pop-up window.

 

[2068Rod]

Thanks Kaper,

Greatly appreciated.

 

[Peter_SSs]

You could also do it by formula. Below is a small example.

BTW, for the future I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with. It will generally get you faster/better responses.

24 08 27.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1		5:00	5:05	5:10	5:15	5:20	5:25	5:30	5:35	5:40	5:45
2	WIC01								x
3	WIC02
4	WIC03		x					x
5	WIC04					x
6	WIC05								x
7	WIC06	x						x			x
8	WIC07			x	x	x
9
10
11	WIC01	5:35
12	WIC03	5:05
13	WIC03	5:30
14	WIC04	5:20
15	WIC05	5:35
16	WIC06	5:00
17	WIC06	5:30
18	WIC06	5:45
19	WIC07	5:10
20	WIC07	5:15
21	WIC07	5:20
22
x

Cell Formulas
Range	Formula
A11:B21	A11	=LET(r,TEXTSPLIT(TEXTJOIN("|",1,IF(B2:K8="x",A2:A8&"#"&B1:K1,"")),"#","|"),IFERROR(--r,r))
Dynamic array formulas.