convert hhmm format to HH:MM Format

[aarona]

Hi All,

Not sure if this is under VBA.

But I need to change the format of columns D to G from hhmm to hh:mm

See attached workbook.

Any help will do.

Thanks!

[jindon]

D2:
=TIMEVALUE(LEFT(C2,2)&":"&MID(C2,3,2))
E2:
=TIMEVALUE(MID(C2,9,2)&":"&RIGHT(C2,2))
F2:
=TIMEVALUE(LEFT(A2,2)&":"&MID(A2,3,2))
G2:
=TIMEVALUE(MID(A2,9,2)&":"&RIGHT(A2,2))

Format the cell as Time and fildown.

[Pepe Le Mokko]

It's actually all over the place if you search the Net https://www.extendoffice.com/documen...g-to-time.html

[aarona]

Thanks! both working