Adding numbers in a cell

Good Morning,

Trying to get a formula right from the attached spreadsheet.

In column E I'm trying to get an automated formula from columns B,C,D

The result I'm trying to get is:
Initials from B, D+D, M+M from C, H+H M+M from D # Number of times name mentioned up until that row
EG:
In row 4
Intiials from B = TI, D+D=8 M+M=1 from C, H+H=4, M+M=14(then again to round down to single digit=5) from D,#01
Resulting in E4 being TI8145#01

I've tried many formulas i've found on Google, but none of these add up to the correct numbers?
I'm not sure if because they are in date and time formats, the : and / may be affecting the formulas?

Any help much appreciated.

Many thanks in advance.

Cool, Thankyou, great start to getting right

Got this so far:
=UPPER(LEFT(B4,1)&MID(B4,FIND(" ",B4&" ")+1,1))&LEFT(DAY(C4),1)+IF(LEN(DAY(C4))>1,RIGHT(DAY(C4),1),0)&LEFT(MONTH(C4),1)+IF(LEN(MONTH(C4))>1,RIGHT(MONTH(C4),1),0)&LEFT(HOUR(D4),1)+IF(LEN(HOUR(D4))>1,RIGHT(HOUR(D4),1),0)&LEFT(MINUTE(D4),1)+IF(LEN(MINUTE(D4))>1,RIGHT(MINUTE(D4),1),0)&"#"&COUNTIF(B4,B4)

Which results in:
TI81414#1

Only 1 part which is not right:
LEFT(MINUTE(D4),1)+IF(LEN(MINUTE(D4))>1,RIGHT(MINUTE(D4),1),0)

Is there a way that if this equals a 2 digit result, the formula goes again to round down to 1 digit

EG:
M+M = 5+9=14, 1+4=5
giving a formula result of: TI8145#1

Many thanks.

Awesome

Thankyou very much, so much appreciated.

I've ammended this so the additional part works on all parts of the formula resulting in:
=UPPER(LEFT(C4,1)&MID(C4,FIND(" ",C4&" ")+1,1))&LEFT(LEFT(DAY(F4),1)+IF(LEN(DAY(F4))>1,RIGHT(DAY(F4),1),0),1)+IF(LEN(LEFT(DAY(F4),1)+IF(LEN(DAY(F4))>1,RIGHT(DAY(F4),1),0))>1,RIGHT(LEFT(DAY(F4),1)+IF(LEN(DAY(F4))>1,RIGHT(DAY(F4),1),0),1),0)&LEFT(LEFT(MONTH(F4),1)+IF(LEN(MONTH(F4))>1,RIGHT(MONTH(F4),1),0),1)+IF(LEN(LEFT(MONTH(F4),1)+IF(LEN(MONTH(F4))>1,RIGHT(MONTH(F4),1),0))>1,RIGHT(LEFT(MONTH(F4),1)+IF(LEN(MONTH(F4))>1,RIGHT(MONTH(F4),1),0),1),0)&LEFT(LEFT(HOUR(G4),1)+IF(LEN(HOUR(G4))>1,RIGHT(HOUR(G4),1),0),1)+IF(LEN(LEFT(HOUR(G4),1)+IF(LEN(HOUR(G4))>1,RIGHT(HOUR(G4),1),0))>1,RIGHT(LEFT(HOUR(G4),1)+IF(LEN(HOUR(G4))>1,RIGHT(HOUR(G4),1),0),1),0)&LEFT(LEFT(MINUTE(G4),1)+IF(LEN(MINUTE(G4))>1,RIGHT(MINUTE(G4),1),0),1)+IF(LEN(LEFT(MINUTE(G4),1)+IF(LEN(MINUTE(G4))>1,RIGHT(MINUTE(G4),1),0))>1,RIGHT(LEFT(MINUTE(G4),1)+IF(LEN(MINUTE(G4))>1,RIGHT(MINUTE(G4),1),0),1),0)&"#"&COUNTIF($C$4:C4,C4)

This is working exactly as planned.

1 more question please if thats ok?
COUNTIF($C$4:C4,C4)
Is it possible please, if this part results in a single digit, the formula adds a 0 to the start resulting in 01, not 1
But if in double digits, leaves the 0 out so 11 would not become 011?

Thankyou so kindly for your assistance.

Perfect.

Thankyou SO! much.