### calculate hours and currency

Posted:

**Wed Apr 13, 2016 2:58 pm**Hi

i'm trying to calculate an HH:mm field of hours worked in the day by hourly rate, to give me a total earnings figure for the day, but cannot find any clues to this formula, trying the basic formula of (F10*10)|gives me an answer of 171000. F10 field is a calculated field 4:45 " 4 hours, 45 minutes * 10 the hourly rate, being a result format of integar, which I was hoping should give an answer of something like 47.50 ??? Not overly experienced in formulas I know somebody has the answer to what seems complcated but is probably simple.

i'm trying to calculate an HH:mm field of hours worked in the day by hourly rate, to give me a total earnings figure for the day, but cannot find any clues to this formula, trying the basic formula of (F10*10)|gives me an answer of 171000. F10 field is a calculated field 4:45 " 4 hours, 45 minutes * 10 the hourly rate, being a result format of integar, which I was hoping should give an answer of something like 47.50 ??? Not overly experienced in formulas I know somebody has the answer to what seems complcated but is probably simple.