Hello,
I have a table with a column where is displayed the time in seconds. I Add another column where I want to displayed the seconds in hours. I have the formula to do that. But it's not working. Can someone please correct this,
DoCmd.RunSQL "UPDATE TableA SET TableA.TimeHours = '" & (Format(Int(TableA.TimeSeconds / 3600), "##0") & ":" & Format(Int((TableA.TimeSeconds - (Int(TableA.TimeSeconds / 3600) * 3600)) / 60), "00") & ":" & Format((TableA.TimeSeconds Mod 60), "00")) & "';"
This will convert 234325 seconds to hh:mm:ss.
Thank you
I have a table with a column where is displayed the time in seconds. I Add another column where I want to displayed the seconds in hours. I have the formula to do that. But it's not working. Can someone please correct this,
DoCmd.RunSQL "UPDATE TableA SET TableA.TimeHours = '" & (Format(Int(TableA.TimeSeconds / 3600), "##0") & ":" & Format(Int((TableA.TimeSeconds - (Int(TableA.TimeSeconds / 3600) * 3600)) / 60), "00") & ":" & Format((TableA.TimeSeconds Mod 60), "00")) & "';"
This will convert 234325 seconds to hh:mm:ss.
Thank you