How to convert Decimal to time

[zaid.ahmad (Qazi Zaid Ahmad)]

Dear Team,
Please help convert decimal time to actual time like (“0.436805555555556”) to (10:29:00)
when i read the file from excel application scope and perform for each row in data table
as string then some value getting right format but some value getting decimal point

Please see the column below

DEAL_TIME
10:29
10:29
12.27
15:12
15.43

Thanks & Regards
Zaid Qazi

[ppr (Peter)]

[postwick (Paul)]

@zaid.ahmad

when i read the file from excel application scope and perform for each row in data table
as string then some value getting right format but some value getting decimal point

Is it possible to address this problem with the source data? It’s always better to fix the source than to try to account for problems by coding around them.

[zaid.ahmad (Qazi Zaid Ahmad)]

Excel has only one column

DEAL_TIME
10:29
10:29
12.27
15:12
15.43

[postwick (Paul)]

My point is if the values are not all formatted the same after reading the data into UiPath then there is a problem with the source file, and you should try to fix that instead of coding around the problem.