web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Total time

Power Apps

Answered

Total time

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi every one i have a problem i don't know File extension

because now i have 2 time = start and stop time in text label screen1

is 2 text is label5 = start and label 5_1 =stopand next screen

and next screen

i have 3 label

label6 = start , label6_1 = stop

label6 i use code label5.Text label6 show start time same screen1 and i use code stop time same start time

now i use code to total is Label6 - Label6_1 = Start time - Stop time

and is error and show The value '9.15.23' cannot be converted to a number.

i want to know how i convert to number or i calculate total time in screen1

if i will calculate total time in screen1 how i can do

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
HI @Anonymous,

Only number value could be compared when doing subtraction.

Generally, we calculate time as below:

DateDiff(StartTime1,EndTime1,Hours)

You should refer to the time value directly instead of label text

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

Like
a
(0)

Report
Copy link

Link copied!

thx for solution but i want to have a time is hh:mm:ss = hour:min:sec
is you solution have a single number
and do you know how i can do to have hh:mm:ss

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

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous，

You mean you want to display the time difference into hh:mm:ss?

If so, please modify your formula as below:

Text(RoundDown(DateDiff(StartTime,EndTime,Seconds)/3600,0),"00")&":"& Text(If(RoundDown(DateDiff(StartTime,EndTime,Seconds)/60,0)>59,0,RoundDown(DateDiff(StartTime,EndTime,Seconds)/60,0)),"00")&":"& Text(Mod(DateDiff(StartTime,EndTime,Seconds),60),"00")

Was this reply helpful? Yes No

Join the conversation