i have a excel table that i want to convert to CSV table. All goes good, exept for the Time field.
Time in Excel is decimal, but i want it in CSV a H:mm:ss.
i already set the list rows present in a table date/time notification to ISO 8601, what made de date field convert with
formatDateTime(item()?['Dag'],'yyyy-MM-dd') goes correct
formatDateTime(item()?['Tijd'],'en-us','H:mm:ss') goes wrong stated that the datetime string is not valid, must conform ISO 8601.
also i tried with addSeconds('1899-12-03', int(formatNumber(mul(float(item()?['Tijd']),86400,'0','en-us')),'H:mm:ss') with te same ISO8601 problem.
I know this item has come forward many times, with many different sollutions, but i did not find one that could solve my problem...
