display seconds as time

  • Thread starter Thread starter Lane
  • Start date Start date
L

Lane

I am attempting to understand time calculation. I searched
and found how to convert time to seconds and then use
seconds in my calculations. This does work for me. I now
have a SUM text box in the footer of my form that shows
time as seconds and I am happy. Now my question.I have this
code to convert seconds to understandable time>>>
--
ElapsedWithDays:
Format(Int([elapsedseconds]/(24*60*60)),"0"" Days """) &
Format(Int([elapsedseconds]/3600) Mod 24,"00\:") &
Format(Int([elapsedseconds]/60) Mod 60,"00\:") &
Format([elapsedseconds] Mod 60,"00")
 
Lane said:
I am attempting to understand time calculation. I searched
and found how to convert time to seconds and then use
seconds in my calculations. This does work for me. I now
have a SUM text box in the footer of my form that shows
time as seconds and I am happy. Now my question.I have this
code to convert seconds to understandable time>>>
--
ElapsedWithDays:
Format(Int([elapsedseconds]/(24*60*60)),"0"" Days """) &
Format(Int([elapsedseconds]/3600) Mod 24,"00\:") &
Format(Int([elapsedseconds]/60) Mod 60,"00\:") &
Format([elapsedseconds] Mod 60,"00")
Click to expand...
format(elapsedseconds/(24*60*60),"hh:nn:ss")

?
 
Back
Top