Calcualation

Question

Hi,

I have a dataset that includes the day and duration that a process was run. On the same day it would have run multiple times and logged the duration. Wanted to know if there is a way to identify the two earliest run from each day? Thanks in advance

WF day        Duration

Mon              05:54:00

Mon              05:59:00

Mon               06:13:00
Tue                06:25:00

Tue                06:26:00

Tue                 12:04:00

Tue                 13:55:00

Qiu · Answer

@apathetichell

Thank you for the advice. It is simplier.

apathetichell · Answer

@QiuI like it! I think you can use: datetimediff([3],"00:00:00","seconds") where [3] is your time column and get the same result - no?

Qiu · Answer

@aparna0208 
If we stick to the word "Calculation"

New Workflow2A.yxmd