Column comparison of date and time for created excel

Hello,
Open the excel Add a column result in column3 (Response time). If sentdate(column 1)>=received date(column 2), substract and enter result in column3 (response time) in excel. Could you help me to design a flow?
Thanks in advance…

@Swetha_V

Can you share your sample input and required output?

Thanks

image
I need output in response time column (within mm:ss format)…

@Swetha_V

I’m not able to see your Image, could check OR you can type the formats

Thanks


Could you check this once… Thanks

@Swetha_V

check below for your reference

For Datetime comparision

For Calaculation of difference

Hope this helps you

Thanks

Workflow running successfully without errors but output not getting to the excel.

Hi @Swetha_V
Check this workflow
sample workflow.zip (4.0 MB)

Regards,

Nived N

Happy Automation

Thankyou i got the output…

Thankyou

did that solution worked for you @Swetha_V

Yes it’s working
Thanks

Kindly mark it as solution so that we can close the thread

done

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