News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps calculate hours betwee...

Power Apps - Building Power Apps

Answered

calculate hours between two dates in text format

Like (0) Share

Report

Report

Posted on 2 Apr 2022 08:28:54 by Community Power Pla...

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.

All responses Img

All responses (5)

Answers Img

Answers (1)

v-qiaqi@microsoft.com on 15 Apr 2022 at 07:34:05

Like (0)

Report

Re: calculate hours between two dates in text format

Hi @madcoderz,

Have you resolved your problem?

If your issue is still, share the details.
EdViegas 436 on 05 Apr 2022 at 15:37:53

Like (0)

Report

Re: calculate hours between two dates in text format

Don't forget RoundUp
Verified answer

v-qiaqi@microsoft.com on 05 Apr 2022 at 04:52:09

Like (1)

Report

Re: calculate hours between two dates in text format

Hi @madcoderz,

Here is what I achieve on my side:

I will suggest you use a Date time picker to display date time value.
Community Power Pla... on 02 Apr 2022 at 20:43:29

Like (0)

Report

Re: calculate hours between two dates in text format

Thanks for the answer but the result is also wrong. Is giving 7 hours when it should be 5 hours.
EdViegas 436 on 02 Apr 2022 at 10:10:57

Like (0)

Report
Re: calculate hours between two dates in text format

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 )