Time duration format

[Ramon]

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

 

[Marshall Barton]

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

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"

 

[Ramon]

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

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

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"

 

[Marshall Barton]

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.

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

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"