'//En Modulo
Public Function ConvHora(Segs As Long) As String
Dim Cadena As String
Dim Horas As Long
Dim Minutos As Long
Dim Segundos As Long
Dim Total As Long
Total = Segs
Horas = 0
Minutos = 0
Segundos = 0
Do While Total <> 0
If Total >= 3600 Then
Horas = Int(Total / 3600)
Total = Total Mod 3600
Else
If Total >= 60 And Total < 3600 Then
Minutos = Int(Total / 60)
Total = Total Mod 60
Else
Segundos = Total
Total = Total Mod 1
End If
End If
Loop
Cadena = Format(Str(Horas) & ":" & Str(Minutos) & ":" & Str(Segundos), "HH:MM:SS")
ConvHora = Cadena
End Function
'//En Form
Private sub Form_Load()
msgbox convhora(120) '//Te devuelve 00:02:00
End sub