Answered

Calculate minutes between two date fields

(0) Share

Report

Posted on by MishkaGrizzly

Apologies if it's been answered before.

I would like to calculate how many minutes there are between two dates:

For example I have these two fields in the following format

CreatedOn: 2025-09-17T10:57:43Z
Modified On: 2025-09-17T11:18:06Z

I read about using ticks function, but is there a simpler way to calculate how many MINUTES it's been between those dates?
The end goal is to find out if it's been 60 mins or more.

Thank you for any help.

Categories:

Business Process Flows

I have the same question (0)

All responses (5)

Answers (1)

MishkaGrizzly 31 on at

Like (0)

Report

Calculate minutes between two date fields

Thank you all, all of the solutions are helpful

Was this reply helpful? Yes No
Tomac 2,167 Moderator on at

Like (2)

Report

Calculate minutes between two date fields

@Chriddle 🤣 It's still real early, if you're ever in the Charlotte NC area I'll buy you a coffee

Was this reply helpful? Yes No
Verified answer

Chriddle 8,112 Super User 2025 Season 2 on at

Like (2)

Report
Calculate minutes between two date fields

I obviously didn't read the last sentence 🤨

Next try: Add an hour to the start and check if it's still less than the end:

less( addToTime(body('Parse_JSON')?['CreatedOn'], 1, 'Hour'), body('Parse_JSON')?['ModifiedOn'] )

Was this reply helpful? Yes No
Suggested answer

Tomac 2,167 Moderator on at

Like (0)

Report
Calculate minutes between two date fields

Hi @MishkaGrizzly

To expand on @Chriddle's great suggestion below, since it doesn't track a raw number of minutes and any number over 60 is converted by the datedifference() function to hours, you'll need to modify the example code a bit:

Int( split( dateDifference( variables('StartDateTime'), variables('ModifiedDateTime') ), ':' )[0] )

To make the entire thing an expression you can use the results of, you would do this:

If( Greater( Int( split( dateDifference( variables('StartDateTime'), variables('ModifiedDateTime') ), ':' )[0] ), 0 ), 'Greater than 60 minutes', 'Less Than 60 Minutes' )

And to use it in a Condition, it would look like this:

Note that the expression in the Condition is the first example from this comment.

While @Chriddle's great example split the returned value and output the minutes, my modification changes it to return the hours and checks if the number of hours is more than 0, which is the same as more than 60 minutes and aligns with how the datedifference() function returns our data.

Hope this helps!

Was this reply helpful? Yes No
Chriddle 8,112 Super User 2025 Season 2 on at

Like (0)

Report
Calculate minutes between two date fields

You could use function dateDifference()

Int( split( dateDifference( body('Parse_JSON')?['CreatedOn'], body('Parse_JSON')?['ModifiedOn'] ), ':' )[1] )

Was this reply helpful? Yes No