Unanswered

Calculating the difference between start and end time. Calculated field required for HH:MM:SS

(0) Share

Report

Posted on by eel1

Hi all,

I have been trying to build a calculated column that calculates the difference between Start and an end time in Dataverse. Both columns are Date and Time data types. I'd like the calculated column sum result to be in the HH:MM:SS format.

I have tried the Datediff calculation and using a TEXT formula eg. TEXT(End Time - Start Time, "hh:mm:ss") but it errors.

Any help on the calculation is much appreciated.

Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report

@eel1 if you're talking about Calculated Columns, TEXT is not a supported function:

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/define-calculated-fields

The same applies to Formula Columns (Power FX):

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/formula-columns

A very fast and effective alternative is to create a Text column in your table, and then use Power Automate to populate that field.

Was this reply helpful? Yes No
LucaAlberigi88 19 on at

Like (1)

Report

Hello
have you tried:
DateDiff(date1,Now(),Hours) & DateDiff(date1,Now(),Minutes) etc?

obviously change date1 and now() with your dates
Luca

Was this reply helpful? Yes No
eel1 56 on at

Like (1)

Report

Thanks both for the replies. I have sorted it, thanks again.

Was this reply helpful? Yes No