Show Numeric Formula Field as Duration
I am creating a time tracking application. Need to allow for entering actual hours and for the use of a clock in/out option. Here is the set up: Time Entries - table to track/enter specific work tas...
Forum Discussion
POP, I figured it out. Changed the field to a duration formula field and changed display to HH:MM.
Issue now is another field that calculates Total Charge, isn't displaying correctly.
Total Charge (currency formula field) is ToHours([Hours Billed])*[Hour Rate]
Hour Rate (currency field) is $100.00
Hours Billed is 00:15
Total Charge should be $25.00 but is displaying as $25.24.