cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Ramole
Level: Powered On

Sum

Hi everyone,
I need help please I have timesheet app I have a field of total hours worked and pay rate field and would like to sum for example if your total hour worked 2 hours and the rate is $10 it will show me automatic $20 total pay

Please help thank you
6 REPLIES 6
Cosechador
Level: Power Up

Re: Sum

Set the Text value of the Sum field to:

Text((Hours.Text * Rate.Text),"[$-en-US]$###,###.##") 

 

 

Ramole
Level: Powered On

Re: Sum

thanks for the replay but it only show blank 

Ramole
Level: Powered On

Re: Sum

my total time worked is calculated automatic via sharepoint and it shows like time 02:43 is there a way to remove the time the 2 dot : like covert to decomol so i can calculate sum thanks

Community Support Team
Community Support Team

Re: Sum

Hi @Ramole 

 

Could you please share more details of your datasource?

You can use DateDiff function to count the hours and multiply.

More information:

function-dateadd-datediff

 

Hope this could be helpful.

 

Best Regards.

Yumia

 

 

Ramole
Level: Powered On

Re: Sum

Hi
My data is Timesheet I have got sign on lunch in - lunch out - time out then I have a field total time worked and rate then another automatic calculation field that count total time worked x Rate = sum,
I have triad to do the calculations via SharePoint but it gives me wrong amount..
Please help thanks
Ramole
Level: Powered On

Timesheet

Can anyone guide me how can I make sign in app from my timesheet example I have timesheet app in PowerApp at moment I have to log the times in and out but would like something they press and it register the times thanks