AnsweredAssumed Answered

Multiply time by rate

Question asked by madeinengland11 on Feb 2, 2019
Latest reply on Feb 2, 2019 by madeinengland11

My question is about  a simple multiplication of time by a rate. In a table "Syllabi" I have "Client hours total" in hours:mins worked & in Rate as a decimal to 2 places.


"Client hours total" is a simple calculation of elapsed time (end time minus start time). The calculation is -


(Syllabi::Rate*Client hrs total)/3600


So far I've not found the right script for the calculation. Dividing by 3600 produces the wrong result in calculation field "Amount Earned". Where am I going wrong I'd be grateful for help here .