I´ve read timers from datatables using VBA in Excel using this code:
Call CopyMemory(resultLong, DB(lAddress * ElementSize + 23), 4)
resultSingle = resultLong / (24 * 60)
resultSingle = resultSingle / (60 * 100)
Workbooks(NombreArchivoDatos).Sheets("Referencias").Cells(lAddress + lRowReadIndex + 2, 4) = resultSingle
Workbooks(NombreArchivoDatos).Sheets("Referencias").Cells(lAddress + lRowReadIndex + 2, 4).NumberFormat = "[hh]:mm:ss.00"
lAddress and ElementSize depends of RAM address of specific datatable you want to read from PLC.