Converting Seconds into Time 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 187 days 9 hours 25
min 48 sec

I have tried
= Format([talk],"dd""days ""hh""hour ""nn""Min ""ss""Sec""") but it does not
return the correct data for results with days included in the seconds.

 

[John Spencer]

Replace the colons with the appropriate words.

Talk =([tt]\86400) & " Days " & Format(([tt]\3600) Mod 24,"00") & "
Hours " & Format(([tt]\60) Mod 60,"00") & " Min " & Format([tt] Mod
60,"00") & " sec"



'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[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 187 days 9 hours 25
min 48 sec

Talk =([tt]\86400) & " days " & Format(([tt]\3600) Mod
24,"00") & " hours " & Format(([tt]\60) Mod 60,"00") & " min
" & Format([tt] Mod 60,"00") & " sec"

or

Talk = tt \ 86400 & " days " & Format(tt / 86400, "hh""
hours ""mm"" min ""ss"" sec""")

 

[Ramon]

Thanks it works great

Replace the colons with the appropriate words.

Talk =([tt]\86400) & " Days " & Format(([tt]\3600) Mod 24,"00") & "
Hours " & Format(([tt]\60) Mod 60,"00") & " Min " & Format([tt] Mod
60,"00") & " sec"



'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

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 187 days 9 hours 25
min 48 sec

I have tried
= Format([talk],"dd""days ""hh""hour ""nn""Min ""ss""Sec""") but it does not
return the correct data for results with days included in the seconds.