Hi, I have an excel spreadsheet where I am counting total hours for work that has been carried out on equipment. I am using a custom format for the cell: -
[h]:mm:ss
I am using 'Get a row', to extract this value and send it as an email but i can't find the correct format to convert the string to the excel cell value i.e. if I have 36:42:30 in the cell, the captured string will be 1899-12-31T12:42:30.000Z
Any suggestions please?