Hi all, i wonder if you can help me out with a little problem. A table that stores order history on our ERP system at work stores the time as seconds past midnight. On that basis, in VBA code, how would i express the number 60915 as hh:mm:ss thanks.
How do i calculate the time from a number that represents seconds after midnight?
- Thread starter hardrock
- Start date
hardrock,
Just add the seconds to the beginning of the the day's date:
Format(DateAdd("s", 60915, Date), "hh:mm:ss")
In a query:
NewField: Format(DateAdd("s", [TimeInSeconds], [YourDate]), "hh:mm:ss")
This assumes that [YourDate] is the date worked and is kept along with
the time.
hth,
Wayne
Just add the seconds to the beginning of the the day's date:
Format(DateAdd("s", 60915, Date), "hh:mm:ss")
In a query:
NewField: Format(DateAdd("s", [TimeInSeconds], [YourDate]), "hh:mm:ss")
This assumes that [YourDate] is the date worked and is kept along with
the time.
hth,
Wayne
Similar threads
