Formula to Calculate Amount Due
I have a table called Task with a one to many relationship to another table called Criteria. On the Criteria table I have the following fields: [Task - Date Identified] (lookup Date/Time) - lo...
Forum Discussion
Quick Base has a simple built in function, ToHours(duration), that will convert your time overdue value to a a number that you can solve your conversion issue. So like this -
ToHours([Time Overdue])*[Deduction]
This will work for 1.5 hours and read as 1.5 * 1000, or in the case of 3 days - it will convert to the # of hours (72) and be 72*1000
ToHours([Time Overdue])*[Deduction]
This will work for 1.5 hours and read as 1.5 * 1000, or in the case of 3 days - it will convert to the # of hours (72) and be 72*1000