AnsweredAssumed Answered

Dividing two fields to get hourly rate

Question asked by colincurtis on Dec 7, 2017
Latest reply on Dec 8, 2017 by colincurtis

I have the following fields: TIME IN, TIME OUT and TOTAL TIME.  TOTAL TIME works well HH:MIN

 

Based to the milage traveled I have a field: WAGE (I manually enter the wage i.e., $50.00)

 

I have a field: AVERAGE HOURLY RATE.

 

How do I get the average hourly rate? Currently I am calculating  by taking WAGE / TOTAL TIME but only getting a fraction of the rate.

Outcomes