Change Date and Time Format in Listview

Hi everyone,

I need some help in formatting listview for date, downtime and uptime column.
I wish to format Date column to dd/mm/yy and downtime & uptime column to hh:mm

Any help would be appreciated, thank you in advance.
Attached with is my excel file.

give the code below a try

Private Sub Loadbarang(akategori As Integer, vkategori As String)
Dim jml As Integer
Dim I As Integer, x As Integer
Dim lis As ListItem
jml = Passdown.Range("DataNo").Count - 1
If jml > 0 Then
    ListView1.ListItems.Clear
    For I = 1 To jml
    Set lis = ListView1.ListItems.Add(, , Passdown.Range("PassdownData").Item(I, 1))
        For x = 1 To 18
                lis.SubItems(x) = Passdown.Range("PassdownData").Item(I, x + 1)
        Next x
 lis.SubItems(13) = Format(lis.SubItems(13), "hh:mm AM/PM")
 lis.SubItems(14) = Format(lis.SubItems(14), "hh:mm AM/PM")
Next I
End If
End Sub

You are re-initializing your form at different points in your code - you only initialize a form once on the initial opening of the form.
Remove the initialize calls and the formatting is then not overwritten, also you need a check on the add button as it can add rows of blank information.
At the same time I will answer your second thread that you have opened on similar topic.
You can not individually color single items in a listview/listbox.

I assume you are saying "how do I check my ADD button" use a code similar to the attached and loop through the controls to ensure data is present.

For x = 1 To 14
If Me.Controls("TextBox" & x).Text = "" Then
Me.Controls("TextBox" & x).BackColor = vbMagenta
MsgBox "Data missing"
Exit Sub
End If
Next x