I am trying to format a formula =IF(E10TIME(10,0,0),E10-TIME(10,0,0),
0), kindly given to me for a time sheet issue. E10 has a formula H10-
G10. In cell F10 is the above formula, which gives 1 hrs overtime,
based on a 10 hr x 4 day week. I now need to calculate over a 10 1/2
hr day, however try as I might the calculation still returns 1 hr
instead if 1/2 an hr. I have tried (10.5 , 10:30) but to no avail. I
am missing something stupidly simple, can anyone help.

The time function is entered as TIME(hour,minute,second)

You need to change the minutes in both TIME functions in the formula. The
first part of the formula tests if E10 is greater than 10:30 and the second
part subtracts 10:30 from E10 if E10 is greater than 10:30. Otherwise returns
zero.

=IF(E10TIME(10,30,0),E10-TIME(10,30,0),0)


--
Regards,

OssieMac


"Decreenisi" wrote:

I am trying to format a formula =IF(E10TIME(10,0,0),E10-TIME(10,0,0),
0), kindly given to me for a time sheet issue. E10 has a formula H10-
G10. In cell F10 is the above formula, which gives 1 hrs overtime,
based on a 10 hr x 4 day week. I now need to calculate over a 10 1/2
hr day, however try as I might the calculation still returns 1 hr
instead if 1/2 an hr. I have tried (10.5 , 10:30) but to no avail. I
am missing something stupidly simple, can anyone help.

On 1 Apr, 11:34, Decreenisi wrote:
I am trying to format a formula =IF(E10TIME(10,0,0),E10-TIME(10,0,0),
0), kindly given to me for a time sheet issue. E10 has a formula H10-
G10. In cell F10 is the above formula, which gives 1 hrs overtime,
based on a 10 hr x 4 day week. I now need to calculate over a 10 1/2
hr day, however try as I might the calculation still returns 1 hr
instead if 1/2 an hr. I have tried (10.5 , 10:30) but to no avail. I
am missing something stupidly simple, can anyone help.

OOOPS ! I have found what I need to know.