1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| Public Function difftemps()
Dim S As Long, H As Long, M As Long
Dim cellule As Range
Set cellule = Application.Caller
If cellule > cellule.Offset(0, 1) Then
S = DateDiff("s", cellule.Offset(0, -2), cellule.Offset(0, -1))
ElseIf cellule < cellule.Offset(0, 1) Then
S = DateDiff("s", cellule.Offset(0, -1), cellule.Offset(0, -2))
End If
H = Int(S / 3600)
M = Int((S - 3600 * H) / 60)
S = S - 3600 * H - 60 * M
'durrée = TimeSerial(H, M, S)
difftemps = H & ":" & M & ":" & S
End Function |
Partager