Hello everyone,

Can anyone please help me, how to read these 2 formulas and what they're basically doing?

1.Created Date
=IF(ISERROR(DATE(LEFT(B2,4),MID(B2,6,2),MID(B2,9,2))),DATE(MID(B2,7,4),MID(B2,4,2),LEFT(B2,2)),DATE(LEFT(B2,4),MID(B2,6,2),MID(B2,9,2)))

2.Time
=TIME(MID(F2,12,2),MID(F2,15,2),0)


Thanks in advance!