Using time in an IF formular

[cmt1963]

Hi all,
Im trying to use an IF formula to calculate an out put in dollars.

The formula is supposed to have a total number of hours that is a sum of hours worked and deduct the overtime trigger of 65 hours. The result is then muliplied by a dollar amount to give overtime dollars earned. The fomular I have is:

=IF(D35>(65/24), ((D35-(65/24)*120)), 0)

The result should be 126 but the answer I get is $-322.25.

Please, any suggestions as to what I'm doing wrong.

 

[Sufiyan97]

Hi & Welcome to MrExcel.

Please post some sample data as we are not able to give any assistance without looking at the data.
You can post data using below XL2BB link

 

[cmt1963]

	FLT/SIM	DH	Total
1​	13:41:00​		13:41:00​
2​			00:00:00​
3​			00:00:00​
4​		20:40:00​	10:20:00​
5​			00:00:00​
6​	12:14:00​	02:55:00​	13:41:30​
7​			00:00:00​
8​			00:00:00​
9​			00:00:00​
10​		07:40:00​	03:50:00​
11​	12:04:00​		12:04:00​
12​			00:00:00​
13​	12:27:00​		12:27:00​
14​			00:00:00​
15​			00:00:00​
16​			00:00:00​
17​			00:00:00​
18​			00:00:00​
19​			00:00:00​
20​			00:00:00​
21​			00:00:00​
22​			00:00:00​
23​			00:00:00​
24​			00:00:00​
25​			00:00:00​
26​			00:00:00​
27​			00:00:00​
28​			00:00:00​
29​			00:00:00​
30​			00:00:00​
31​			00:00:00​
	50:26:00​	31:15:00​	66:03:30​
		OT Pay	-$322.25​

 

[cmt1963]

I couldn't get the xl2bb.xlam to install in office 365. I"ll have a go at using the alternative method.