Help with capturing the run time of an automation correctly

Help Activities
, , ,
1

I need help with ensuring that my automation is capturing the time of run anytime the automation executes. Currently, it is overlaying the time of run with the time of last run.

I have a business need to format some numbers, then after formatting these numbers:

  1. I used write Range workbook to write the formatted records to sheet1 of my excel sheet.
    ( we dont want to append here)

  2. I used 'Append Range workbook to write the same record to sheet2. BUT, my automation wants to always keep record of all the formatted records, hence the reason for the append.

In addition to appending these records in sheet2, I also want to capture the time automation append records and not overlay this time.

So for example, this fist screenshot is what I was expecting
image

but my automation is always overlaying the previous time of run with the last time of run- as seen below.
image

How can I ensure that I get the expected behavior in the first screenshot. Attached is my workflow.

image
image878×761 25.7 KB

howToAppendRunOutPutToExcelSheet.zip (18.5 KB)