UPDATE ......From Tuesday 8 April 2025 we have changed the way that Single Sign-on works on this wiki. Please see here for more information:
Update
...
Now we need to convert the duration time in seconds into the format hours:minutes:seconds, to do this right-click the column header for column D and select format cells. In the Number tab, select the Custom Category, then in the type list, select hh:mm:ss
** WARNING - Watch out for times that are greater that 23:59:59, as they will not be converted properly. Please refer to the section.
In Column E, Row 1, create a formula =CONCATENATE("UPDATE report_service_availability SET out_maint='",TEXT(D1,"hh:mm:ss"),"' WHERE base_absid = ",A1," AND year = 2017 AND month = 7 ;"). Drag this formula down the length of the number of rows with data in it to complete the column of SQL statements.
...