VBA to split date and time

Originally Posted by mancubus

hi.

assuming A1 houses the date, try this:

Sub split_date_time()

    Range("B1").Value = Format(Int(Range("A1")), "dd/mm/yyyy")
    Range("C1").Value = Format((Range("A1") - Int(Range("A1"))), "hh:mm:ss")

End Sub

Good, but you need to incorporate it on a loop as the OP has lots of rows.