formating probelms

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.
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Forum statistics

Threads
1,213,526
Messages
6,114,122
Members
448,550
Latest member
CAT RG

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top