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:

The formula I am using for the Deduction Starts field is:

If(ToText([Task - Date Identified])<>"",([Task - Date Identified]+[Deduction Period]))

The formula for Time Overdue is:

If(IsNull([Date Complete]) and Days([Time Used])>[Deduction Period],(Now()-[Deficiency Deductions Start]),

(not IsNull([Date Complete]) and Days([Time Used])>[Deduction Period]), ([Date Complete]-[Deficiency Deductions Start]))

And finally, my formula for Total Deductions is:

([Time Overdue]*[Deduction])

With the formulas here is what is happening.

Task - Date Identified =

Deductions Start =

Date Complete =

Deduction Period =

Time Overdue =

Deduction =

Total Deduction = Formula error says "Expecting Number but found duration"

What I need this to do is show the time overdue as 1.5 hours which it does, but then I need it to take the 1.5 hours & multiply it by $1000. But it has to work regardless if the Time Overdue is 1.5 hours or 3 days. Can someone help me.

On the Criteria table I have the following fields:

- [Task - Date Identified] (lookup Date/Time) - looks up the date in which the Task was identified.

- [Date Complete]- Date/Time - tells at what date & time criteria was complete.

- [Deduction Period] - Duration (days/hours) - Tells us how long we have to complete the task criteria before we begin to be charged

- [Deduction]- Currency - tell us how much we will be charged for each deduction period after the allowed time

- Deficiency Deductions Start] - Formula Date/Time - tells us what time or date the deductions are going to start -
- ([Task - Date Identified]+[Deduction Period])

- [Time Used] - Formula Numeric - Tell us how much time we have used to complete the task criteria
- If(IsNull([Date Complete]),ToDays(Now()-[Task - Date Identified]),ToDays([Date Complete]-[Task - Date Identified]))

- [% of Days Used] - Formula % - Used for a Performance Bar formula
- Days([Time Used])/[Deduction Period]

- [Time Overdue] - Formula Duration - tell us the amount of time we went past the Deduction Period
- If(IsNull([Date Complete]) and Days([Time Used])>[Deduction Period],(Now()-[Deficiency Deductions Start]),

(not IsNull([Date Complete]) and Days([Time Used])>[Deduction Period]), ([Date Complete]-[Deficiency Deductions Start]))

- [Total Deduction] - Formula Currency - calculates how much we should deduct from our monthly invoice.
- ([Time Overdue]*[Deduction])

**Now, here is the problem. My Total Deduction formula isn't working.**The formula I am using for the Deduction Starts field is:

If(ToText([Task - Date Identified])<>"",([Task - Date Identified]+[Deduction Period]))

The formula for Time Overdue is:

If(IsNull([Date Complete]) and Days([Time Used])>[Deduction Period],(Now()-[Deficiency Deductions Start]),

(not IsNull([Date Complete]) and Days([Time Used])>[Deduction Period]), ([Date Complete]-[Deficiency Deductions Start]))

And finally, my formula for Total Deductions is:

([Time Overdue]*[Deduction])

With the formulas here is what is happening.

Task - Date Identified =

__09-19-2018 12:00 AM__Deductions Start =

__09-19-2018 01:00 AM__Date Complete =

__09-19-2018 02:30 AM__Deduction Period =

__1 hour__Time Overdue =

__1.5 hours__Deduction =

__$1,000__Total Deduction = Formula error says "Expecting Number but found duration"

What I need this to do is show the time overdue as 1.5 hours which it does, but then I need it to take the 1.5 hours & multiply it by $1000. But it has to work regardless if the Time Overdue is 1.5 hours or 3 days. Can someone help me.