web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Need help with a Excel...

Power Apps

Unanswered

Need help with a Excel calculation and display it in the right way in Power Aps

(0) Share

Report

Report

Posted on by JCB02

79

Hi

I have this calculation in Excel, and want to translate and do it in Power Apps.

=K2+ABS(I2-G2)/L2/1440

K2 = Time format, ex: 00:00:13

I2 = Numbers without decimals, ex: 1456

G2 = Numbers without decimals, ex: 1380

L2 = Numbers with decimal, ex: 48,00

And the answer is displayed in a time format: 00:01:48

Now, in Power Apps I have done some stuff, but I cant get this last piece to work.

K2 in Power Apps is from my timer "Time1_Text"

I2 in Power Apps is from a input named "Input_2"

G2 in Power Apps is from a input named "Input_3"

L2 in Power Apps is from a calculation "(Input_1 - Input_2) / (DateDiff( Time1_Text, Time2_Text, Seconds ) / 60) "

I need this calculation to be displayed in time format: "00:00:00"

Is there anyone here that can help me with this calculation I am trying to get to work?

If you use my number above, then the result should be "00:01:48" in this calculation.

And I dont know how to solve this in Power Apps.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

anasurielnh Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @JCB02 I was trying to check up on your issue, but I had some trouble understanding the part where you said
K2 in Power Apps is from my timer "Time1_Text"
I2 in Power Apps is from a input named "Input_2"
G2 in Power Apps is from a input named "Input_3"
L2 in Power Apps is from a calculation "(Input_1 - Input_2) / (DateDiff( Time1_Text, Time2_Text, Seconds ) / 60)

What is Time2_Text showed in L2? Could you please expand?

Also, I would recommend to use a command like
Text(((Input1-Input2)/(TimeValue("00:00:13"))/60),"hh:mm:ss")
If what you need is to give the correct format to the calculation that should do the trick.

Regards,
Community Support Team - Ana Navarro Hernandez
If this post helps, then please consider accepting it as the solution to help the other members find it more quickly.
JCB02 79 on at

Like
a
(0)

Report
Copy link

Link copied!

@anasurielnh Hello, thanks for answer.
I will try to answer you in best way.
This formula "=K2+ABS(I2-G2)/L2/1440" is used in my Excel file to do a calculation.
And this is what Excel have in the cells that are in the calculation:
K2 = Time format, ex: 00:00:13
I2 = Numbers without decimals, ex: 1456
G2 = Numbers without decimals, ex: 1380
L2 = Numbers with decimal, ex: 48,00
And the answer to this calculation in Excel is displayed in a time format: 00:01:48

And in Power Apps
"Excel's K2" in my Power Apps is from my timer "Time1_Text"
"Excel's I2" in my Power Apps is from a input named "Input_2"
"Excel's G2" in my Power Apps is from a input named "Input_3"
"Excel's L2" in my Power Apps is from a calculation "(Input_1 - Input_2) / (DateDiff( Time1_Text, Time2_Text, Seconds ) / 60)
But I will now try your calculation in the last one later.

So what I am trying to get (If I translate it directly from Excel) in Power Apps is something like this:

"Time1_Text+(Input_2-Input_3)/(Input_1 - Input_2) / (DateDiff( Time1_Text, Time2_Text, Seconds ) / 60)/ And so on."
To get the right calculation to show me a answer in time format like Excel do.

I really dont know how to explain it better, sorry.
I did a small sample in Power Apps, maybe that helps?

Thanks.

calculation examp...

Join the conversation