web

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

News and Announcements icon

Power Platform CommunityForums Power Apps datediff display as hh:mm

Power Apps

Answered

datediff display as hh:mm

(0) Share

Report

Report

Posted on by mrleetyler

270

hi all

i am trying to do a DateDiff and display the result as a time factor.

e.g. 13:00 start 14:00 end i'd want the datediff to display at 01:00 not 60,1,3600 etc.

i'm working with this at the moment but it just doesn't work

the date diff displays correctly but i cannot get the format of the seconds converted to a time factor

is there a way to do this?

Text(DateDiff(DateTimeValue(input_ShiftStart.Text),DateTimeValue(input_ShiftEnd.Text),Seconds),"[$-en-US]hh:mm")

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @mrleetyler
Text(DateDiff(TimeValue(input_ShiftStart.Text),TimeValue(input_ShiftEnd.Text),Hours), "[$-en-US]00") & ":00"

Was this reply helpful? Yes No
mrleetyler 270 on at

Like (0)

Report
Copy link

Link copied!

hey Stalin,

that works fine for exact hours but in the event of for example a 90 minute datediff this method won't work

Was this reply helpful? Yes No
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @mrleetyler

Minutes Included.
Text(DateDiff(TimeValue(input_ShiftStart.Text),TimeValue(input_ShiftEnd.Text),Hours), "[$-en-US]00") & ":" & Text(Mod(DateDiff(TimeValue(input_ShiftStart.Text),TimeValue(input_ShiftEnd.Text),Minutes), 60),"[$-en-US]00")

Was this reply helpful? Yes No

Join the conversation