Answered

Convert calculated field stored as day value in SharePoint List to hh:mm

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a SharePoint list that records people's start and finish time for a shifts, and records the difference between the two dates as a day like so:

I would like to display these values in Sum a sum function in a PowerApp, but displaying as 08:00, rather than a decimal representing days, as below. Any advice would be appreciated! Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Check this thread:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Displaying-date-difference-in-both-hours-and-minutes/td-p/278958

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
Verified answer

CU-18081211-6 9,270 Moderator on at

Like (1)

Report
Copy link

Link copied!

@Anonymous ,

Sharepoint calculated columns are not quite reliable in relation with PowerApps. So I wonder why don’t calculate the difference between two times values in powerapps directly. There is a function to do it:

DateDiff(StartTime,EndTime,Hours)

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

Like (0)

Report
Copy link

Link copied!

Thanks @gabibalaban - your advice about calculating the difference in powerapps directly was spot on.

Was this reply helpful? Yes No