web

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

News and Announcements icon

Power Platform CommunityForums Power Apps calculate hours betwee...

Power Apps

Answered

calculate hours between two dates in text format

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everybody. I need to calculate hours between two dates from a text label. What i tried is giving me 6 hours as a result.

Here´s what i spect:

StartDate: 20/02/2022 23:00

EndDate: 21/02/2022 04:30

Total Hours: 5 hours

This is what i tried:

"Total Hours: " & DateDiff(DateTimeValue(start_date_label.Text); DateTimeValue(end_date_label.Text);Hours)

Any help will be much appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

Sort by

EdViegas 436 on at

Like
a
(0)

Report
Copy link

Link copied!
TextInput1: "01 Mar 2022 11:00 PM"
TextInput1_1: "02 Mar 2022 04:30 AM"
Label: Total hours: 6

"Total Hours: " & RoundUp( DateDiff( DateTimeValue(TextInput1.Text), DateTimeValue(TextInput1_1.Text), Minutes ) / 60, 0 )

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the answer but the result is also wrong. Is giving 7 hours when it should be 5 hours.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @madcoderz,

Here is what I achieve on my side:

I will suggest you use a Date time picker to display date time value.

Was this reply helpful? Yes No
EdViegas 436 on at

Like
a
(0)

Report
Copy link

Link copied!

Don't forget RoundUp

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @madcoderz,

Have you resolved your problem?

If your issue is still, share the details.

Was this reply helpful? Yes No

Join the conversation