How to Convert time to text string in excel?

Help Studio
1

hello,

i have a column that contains date time in format “dd MM yyyy HH mm ss” and ‘custom’ format. I need to convert it to text. In excel it can be done with TEXT function:

=TEXT(A1;“dd MM yyyy HH mm ss”)

how can i do it with uipath ?

2

read data from each row of your excel from that particular column and store it in a variable. Then you can use YourDateTimeVariable.ToString() and write it back to same cell use write cell activity

1 Like
3

Hi @Welcoming

Use read cell and strore in a particular variable (lets assume strText)

In assign activity
strText = cdate(strText).tostring(“dd MM yyyy HH mm ss”)

Instead of 12-11-2020 pass the variable strText

image

4

Hi @Welcoming

In addition to what @Surya_Narayana_Korivipadu said tick the preserve format range while reading the excel file

5

@NIVED_NAMBIAR @prasath_S @Surya_Narayana_Korivipadu

image

The robot extracts ‘0.625’ and in the excel file it says “15:00” …

6

can you show the excel file data and the xaml to get the clearer picture

7

image
image542×672 15.9 KB

8

I am just using ‘read cell’ and when i store it in a variable, when using a log message it writes ‘0.625’ for 15:00

9

could you please send the excel file and xaml file you are using because in my end it is working fine

10

@Welcoming
have a look here:
grafik

11

@Welcoming

Check below for your reference

Hope this may help you

Thanks