Read Range DateTime from Excel and determine that value more or less

Help
, , ,
1

Hello All,

i have some issue when reading excel file which that column formate with time it will be output like this :
image
excel file : sample.xlsx (8.1 KB)
Note: i want determine each that time more or less than 8:30AM and if any value more than 8:30AM i want to edit that value to 8:30AM and write again into same excell.

Thankyou

2

@aliaga
on your log message/write line activity
Timevariable.ToString(“hh:mm:ss”)

3

Hi @aliaga

Try this timevariable.ToString(“hh:mm:as tt”)

Thanks
Ashwin.S

4

Hello @jcvsalinas,

am i wrong implement this code, it will output like this.

image
image912×424 8.26 KB

5

Hello @AshwinS2,

im already try this but have same issue with this Read Range DateTime from Excel and determine that value more or less - #4 by aliaga

6

Hi @aliaga
Have you tried like this

Cdate(waktu.ToString).ToString(“hh:mm:ss tt”)

Thanks
Ashwin S

7

Hello @AshwinS2,

it will return error like this

image
image808×405 6.21 KB

8

Hi @aliaga
try DateTime.Parseeexact(waktu.ToString,“”,System.Globalisation.InvariantCulture.CultureInfo,“dd/MM/yyyy hh:mm:ss tt”)

Thanks
Ashwin S

9

Solution :

  1. Using Format Value Activity
    image
  2. Determine time less or more than certain time using if from integer/double value from read range
    image

Thankyou All (@AshwinS2, and @jcvsalinas)

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.