Unanswered

Problem calculating the duration whit Date Diff

(0) Share

Report

Posted on by pracmt1515

Hello im using an excel file stored on one drive,

So im calculating in my app the duration of some activities where i can put the initial date and the end date of the activity, and im using Date diff to calculate the duration of the activity,

So for example the initial date was 00:00:00 and the final date was 00:10:00 so the duration will be 10 minutes or 0,167 hours (ill leave a pic of the problem down there), so far so good the app shows me the 0,167 value as a duration, but when i save that and check the excel file on one drive, the duration appears like 167, which clearly is the incorrect value, it is like the app or something is multiplying by 1000 at some point .

im using a datacard whit the function: Value(Round((DateDiff(TimeValue(HoraInicio.Text);TimeValue(HoraFin.Text);Minutes)/60);3);"es-ES"))

where:

Hora inicio is the initial date in hours,
Hora Fin is the final date in hours,

Duración.PNG

Ill appreciate some help,

Stay safe out there.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Vijay Tailor 2,961 on at

Like (1)

Report
Copy link

Link copied!

Hi @pracmt1515 ,

For this Requirment.

You need to change the Formatting For Excel Field that resides in Onedrive Excel Table.
Basically, PowerAPp Pass the correct data but this value change on the excel side.

please change the Excel Column Formatting to Text or something else that fits your requirement.

Thanks,
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
pracmt1515 15 on at

Like (0)

Report
Copy link

Link copied!

I try it but it didn't work, im thinking that the problem may be that the number is too small so excel confuses the coma whit a dot, and that changes the value of 0,167 to 167,
¿what do you think?, maybe a solution for that is to put the duration in minutes and not in hours.

Was this reply helpful? Yes No
Vijay Tailor 2,961 on at

Like (0)

Report
Copy link

Link copied!

Hi @pracmt1515 ,

Change the Excel Column Formate as Text.

And Pass the value a text from Power App.
Thanks,
Hope to help you to resolve your Issue

Was this reply helpful? Yes No
pracmt1515 15 on at

Like (1)

Report
Copy link

Link copied!

Thanks ill let you know if it works,
Stay safe!

Was this reply helpful? Yes No