Time duration format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am useing
Talk =([tt]\86400) & ":" & Format(([tt]\3600) Mod 24,"00") & ":" &
Format(([tt]\60) Mod 60,"00") & ":" & Format([tt] Mod 60,"00")

to convert 16190748 seconds into Time format the result i recieve is
187:09:25:48. I would like to have this time formated as 4,447hrs ##mins
##sec
 
Ramon said:
i am useing
Talk =([tt]\86400) & ":" & Format(([tt]\3600) Mod 24,"00") & ":" &
Format(([tt]\60) Mod 60,"00") & ":" & Format([tt] Mod 60,"00")

to convert 16190748 seconds into Time format the result i recieve is
187:09:25:48. I would like to have this time formated as 4,447hrs ##mins
##sec
Click to expand...


Make up your mind ;-) Your other post wanted a different
result from the same expression. What did you do, copy it
from somewhere without understanding what it does?

This time use something more like:

Talk = Format(tt \ 3600,"#,##0") & " hrs " & Format((tt Mod
3600) \ 60,"00") & " mins " & Format(tt Mod 60,"00") & "
secs"
 
Thanks Marshall I decided to go with this format and it works perfectly i
really appreciate the help.

Marshall Barton said:
Ramon said:
i am useing
Talk =([tt]\86400) & ":" & Format(([tt]\3600) Mod 24,"00") & ":" &
Format(([tt]\60) Mod 60,"00") & ":" & Format([tt] Mod 60,"00")

to convert 16190748 seconds into Time format the result i recieve is
187:09:25:48. I would like to have this time formated as 4,447hrs ##mins
##sec
Click to expand...


Make up your mind ;-) Your other post wanted a different
result from the same expression. What did you do, copy it
from somewhere without understanding what it does?

This time use something more like:

Talk = Format(tt \ 3600,"#,##0") & " hrs " & Format((tt Mod
3600) \ 60,"00") & " mins " & Format(tt Mod 60,"00") & "
secs"
Click to expand...
 
I am happy that you have what you needed.
--
Marsh

Thanks Marshall I decided to go with this format and it works perfectly i
really appreciate the help.

Marshall Barton said:
Ramon said:
i am useing
Talk =([tt]\86400) & ":" & Format(([tt]\3600) Mod 24,"00") & ":" &
Format(([tt]\60) Mod 60,"00") & ":" & Format([tt] Mod 60,"00")

to convert 16190748 seconds into Time format the result i recieve is
187:09:25:48. I would like to have this time formated as 4,447hrs ##mins
##sec
Click to expand...


Make up your mind ;-) Your other post wanted a different
result from the same expression. What did you do, copy it
from somewhere without understanding what it does?

This time use something more like:

Talk = Format(tt \ 3600,"#,##0") & " hrs " & Format((tt Mod
3600) \ 60,"00") & " mins " & Format(tt Mod 60,"00") & "
secs"
Click to expand...
Click to expand...
 
Back
Top