Duration calculation

[alhazen]

Hello,

I am not sure what happened here, but the formula performed an incorrect calculation. It shows the correct result in form view, but when I save it, the value changes to $44. I used the following formula: (HOUR([hours_tracked]) + MINUTE([hours_tracked])/60) * [rate]

Would anyone be kind enough to provide me with some insights? I appreciate your consideration. Thank you

[Suvrutt_Gurjar]

Please try 

TOTALHOURS([hours_tracked] -"00:00:00")*[rate]

if [hours_tracked] is a time type column.

or please try 

TOTALHOURS([hours_tracked])*[rate]

if [hours_tracked] is a duration type column.

TOTALHOURS() - AppSheet Help