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
...
** WARNING - Watch out for times that are greater that 23:59:59, as they will not be converted properly. Please refer to the WARNINGS in the 3.1 Availability 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.
...