Hi, I'm trying to format Time in string format to Time format hh:mm:ss. Example below
0.70998842592593003 0.52896990740741001 0.57854166666666995
Any help would be much appreciated. Thanks Ewa
@Carlithian Thank you for the adding up.
@fieldew1 Right click on the workflow link and choose "Save As" should make you be able to download the flow.
I’ve never seen decimals as times - What is the logic to convert these into times? What value should they each be?
@fieldew1 According ChatGPT, those values look very much like fractions of a day (common in Excel, SQL Server, OLE Automation dates, or CSV exports).
So we do something like below.
within Excel file I do text to column and change a format to time but I wanted this step to be part of the workflow
Thanks @Qiu, I don't seem to be able to download the workflow. When adding the formula I do get 00:00:00 across all. The initial entry is vstring so not sure if I should add an additional step to convert it to time?
@fieldew1 you want the field to be a double to use it in Quis formula, Ive tried it with the data being double and it works, as a string the formula errors, so surprised you get anything out of it at all
Thank you @Qiu and @Carlithian, all worked perfectly!
