How to convert Decimal to time

Help Studio
, ,
1

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

2

grafik

1 Like
3

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.

4

Excel has only one column

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

5

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.