web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Date DIfference in min...

Power Automate

Unanswered

Date DIfference in mins, hrs and days

(0) Share

Report

Report

Posted on by jaina

517

Hello,

I'm trying to create a TAT based on date difference and i wanted to display in mins, hrs and days...

Here's the formula i used

Mins:

div(sub(ticks(body('AUTOMATION_COMPLETION_DATE')),ticks(body('LAST_APPROVAL_DATE'))),600000000)

Hrs:

div(sub(ticks(body('AUTOMATION_COMPLETION_DATE')), ticks(body('LAST_APPROVAL_DATE'))), 36000000000)

Days:

div(sub(ticks(body('AUTOMATION_COMPLETION_DATE')), ticks(body('LAST_APPROVAL_DATE'))), 864000000000)

and Here's the output data. How can I achieve to get the correct mins, hrs and days, say in below example, the result should be

from 0 days, 1 hrs, 78 mins to 0 days, 1 hrs, 18 mins and from 0 days, 1 hrs, 81 mins to 0 days, 1 hrs, 21 mins.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

The DateDifference function will give you the difference between two dates in Days, hours, minutes, seconds formatted as days.hours:minutes:seconds. You can then take that string and split it into an array to get the individual days, hours, minutes etc. You can read about it here: Reference guide for expression functions - Azure Logic Apps | Microsoft Learn

Was this reply helpful? Yes No
Verified answer

v-liwei-msft on at

Like (1)

Report
Hi @jaina

You can try

As for minutes:

if(lessOrEquals(div(sub(ticks(body('AUTOMATION_COMPLETION_DATE')),ticks(body('LAST_APPROVAL_DATE'))),600000000),60),div(sub(ticks(body('AUTOMATION_COMPLETION_DATE')),ticks(body('LAST_APPROVAL_DATE'))),600000000),mod(div(sub(ticks(body('AUTOMATION_COMPLETION_DATE')),ticks(body('LAST_APPROVAL_DATE'))),600000000),60))

As for hours:

if(lessOrEquals(div(sub(ticks(body('AUTOMATION_COMPLETION_DATE')),ticks(body('LAST_APPROVAL_DATE'))),36000000000),24),div(sub(ticks(body('AUTOMATION_COMPLETION_DATE')),ticks(body('LAST_APPROVAL_DATE'))),36000000000),mod(div(sub(ticks(body('AUTOMATION_COMPLETION_DATE')),ticks(body('LAST_APPROVAL_DATE'))),36000000000),24))

Best Regards,

Levi

1 people found this reply helpful.

Was this reply helpful? Yes No

Join the conversation