web

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

News and Announcements icon

Power Platform CommunityForums Power Apps DateDiff Days Hours Mi...

Power Apps

Answered

DateDiff Days Hours Minutes

(0) Share

Report

Report

Posted on by Draqon

23

Hello again,I’m struggling with a DateDiff funciton. I have two dates with hours and minutes values. I want to check how many hours of difference there is and divide it by 24 hours, get a number of days left and spare hours which will be used later on.

DateValue1

HourValue1

MinuteValue1

DateValue2

HourValue2

MinuteValue2

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Draqon

Days between

RoundDown(DateDiff(DateValue2.SelectedDate + Time(HourValue2.Selected.Value, MinuteValue2.Selected.Value,0), DateValue1.SelectedDate + Time(HourValue1.Selected.Value, MinuteValue1.Selected.Value,0), Days),0)

Spare hours

RoundDown(Mod(DateDiff(DateValue2.SelectedDate + Time(HourValue2.Selected.Value, MinuteValue2.Selected.Value,0), DateValue1.SelectedDate + Time(HourValue1.Selected.Value, MinuteValue1.Selected.Value,0), Hours), 24),0)

Spare minutes

RoundDown(Mod(DateDiff(DateValue2.SelectedDate + Time(HourValue2.Selected.Value, MinuteValue2.Selected.Value,0), DateValue1.SelectedDate + Time(HourValue1.Selected.Value, MinuteValue1.Selected.Value,0), Minutes), 60),0)

---
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

Join the conversation