zimmer9
asked on
Do you know how to compute seconds into hours, minutes and seconds via an Excel macro?
Do you know how to compute seconds into hours, minutes and seconds via an Excel macro?
I tried the following but got a syntax error?
Private Sub CommandButton1_Click()
=TIME(INT(A2/3600),INT(MOD (A2,3600)/ 60),MOD(MO D(A2,3600) ,60))
End Sub
I tried the following but got a syntax error?
Private Sub CommandButton1_Click()
=TIME(INT(A2/3600),INT(MOD
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.