I think you've just confused which column to format.
According to your example, the time column is col 3. This will be the reference cell (column 1) offset by 2 columns[VBA].ListItems.Add , , Cell
.ListItems(X).ListSubItems.Add , , Cell.Offset(0, 1)
.ListItems(X).ListSubItems.Add , , Format(Cell.Offset(0, 2), "hh:mm")
.ListItems(X).ListSubItems.Add , , Cell.Offset(0, 3)[/VBA]