Bridge compare date/time module output

Question

I have a flow that runs every 15 minutes and it compares the date and time the row was created with the current time and it writes that difference in time to a column to easily show how long a row has been waiting to be worked.

The only thing I'd like to change is to make time value it updates each row with always be a number rather than the default as shown below…

I have this feeding a Power BI worksheet where we run some calculations with this time.  Either straight minutes would work or maybe one decimal place if it had to be hours.

I didnt find anything on this posted… Hopefully someone knows a trick?

Genevieve P. · Accepted Answer

Hi @JohnRitchey

It looks like you're taking the "humanized" output from the Compare Date/Time module, which is why you're seeing the rounded number:

What I would personally do here is grab the Seconds (my second arrow) and throw that into an adjacent column. Then you can use a formula to translate it to hours/minutes, etc. Or you can grab the minutes directly! This will give you a numerical value to work with instead of text.

Cheers,

Genevieve