Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Keywords: Time Format Excel Hours Minutes Date Decimal Number h:mm
To convert hours from decimal number to the standard time format (hours : minutes : seconds) use the TEXT function. The code might look something like this:
; Reading & Displaying Time Values From Excel format = XLObject.Cells(98,1).NumberFormat ; determines the format of the cell in Excel replayTime = XLObject.Cells(98,1).Value ; read the cell replayTime = XLObject.TEXT(replayTime, format); format cell for display, using previously determined format Message("Time",replayTime)
Article ID: W18108
Filename: Excel Time Format.txt
File Created: 2011:01:24:10:36:50
Last Updated: 2011:01:24:10:36:50