drag-driver
Board Regular
- Joined
- Feb 18, 2002
- Messages
- 91
I have a formula like this:
=IF(N2,B3+($J$7 - B2),0)
where N2 is true or false
b3 and b2 are time values
j7 is a time value
The calculation works corectly and shows may a solution in a time format. I then want to referance only time values greather than 2:00 but it will not do this, however if i use the filter to find a value = to a value in the list it does so. I tried copying the values to a new sheet but it then changes my format and adds in a date at the begining of the number, this is not printed in the cell but can be seen when you look in the cell ref. I cannot get it to show the times i want.
=IF(N2,B3+($J$7 - B2),0)
where N2 is true or false
b3 and b2 are time values
j7 is a time value
The calculation works corectly and shows may a solution in a time format. I then want to referance only time values greather than 2:00 but it will not do this, however if i use the filter to find a value = to a value in the list it does so. I tried copying the values to a new sheet but it then changes my format and adds in a date at the begining of the number, this is not printed in the cell but can be seen when you look in the cell ref. I cannot get it to show the times i want.