TimeDiff Calculation

[Tarek_Kariish]

Hey Community!

Trying to calculate time diff, I have 2 Excel col ( Start Time ) ( End time ) that has different time like that :

02/17/2023 14:15:41 02/17/2023 14:15:51

I’m inside a for each row loop and doing this as follows:

But getting this Error:

Appreciate any help!
Thnx

[Anil_G (Anil Gorthi)]

@Tarek_Kariish

Can you first use a log message and print row("StartTime").ToString and similarly end time and check the format of the date

cheers

[RajKumar_DC (RajKumar Durai)]

Hi @Tarek_Kariish,

If you get value is DateTime value only you can use below workflow.

Workflow

Sample Input and Output

Thanks,

[Tarek_Kariish]

Thank you very much, works Perfectly!