display seconds as time

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")
 
B

Bas Cost Budde

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")

?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting Seconds to Hours, Minutes, Seconds 3
Date and Time questions 8
Why can't Access find my table? 2
Time duration format 3
Converting Seconds into Time Format 3
Elapsed Time Format 3
Seconds as DD:HH:MM:SS 2
Text box Formula Error Message 2

Top