如何在Excel中显示hh：mm：ss？-Howtodisplayhh:mm:ssinExcel?

4  

This Should do it, have Fun. :-)

这应该做到,玩得开心。 :-)

Option Explicit
Sub test()
    Dim i&, sTime As Date, TimeStep As Date, Cell As Range
    '// Format range cell to 24Hrs
    With Range("A1:A1440") '// 24H*60M
        .NumberFormat = "HH:MM:SS;@"
    End With

    Set Cell = [A1] '// first cell to write
        sTime = "00:00:00"  '// start time
    '// Loop 24hrs
    TimeStep = "00:01:00" '// time increment
    For i = 0 To 1439 ' // 1439 means 1439 cells
        Cell.Offset(i, 0).Value = sTime
        sTime = sTime + TimeStep
    Next i
End Sub

Start

End

3  

ok, now that you explained a bit in more depth,

好的,既然你有更深入的解释,

ActiveSheet.Cells(1, 1).Value = "00:00:00"
ActiveSheet.Cells(2, 1).Value = "00:01:00"
Range("A1:A2").Select
Selection.AutoFill Destination:=Range("A1:A1440"), Type:=xlFillDefault

should do the trick

应该做的伎俩

0  

To retrieve time format you can use:

要检索时间格式,您可以使用:

=Mid(A1,11,8)*1 into function bar (with additional column)

or into a sub

或者成子

timeOnClock= Mid(MyString, 10, 9)*1

then for your first row (23-Oct-13 10:00:00 AM SGT) you retrieve 0,416666667 and you can choice your prefer format

那么你的第一行(23-Oct-13 10:00:00 SGT)你检索0,416666667,你可以选择你喜欢的格式