web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Time Diffrence Calcula...

Power Apps

Unanswered

Time Diffrence Calculation

(0) Share

Report

Report

Posted on by Bilal_26

2

Hello,

I want to calculate the time difference between two selected values. But when time selection goes beyond the 30 minutes it adds an extra hour into the computed time difference.

When I select the value below 30 it calculates the correct time but above 30 it won't.

I have attached the screenshots for reference... Please help.

(I'm using SharePoint list as a data source and Date and Time column type.)

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Bilal_26 I did some testing on my end and could not recreate this issue.
However, could you try to enclose the Date values in a DateValue() function:

DateValue(DateEmailIn.SelectedDate) + Time ....
In the Hours part of the function for both DateEmailIn & DateEmailPicked.

I hope this helps!
Bilal_26 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LaurensM ,

Thanks for your response

Your solution is working under the same selected hour, However when I change the hour value it is not calculating it.

Join the conversation