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.