Hi all, if you look at attachment, in Cell J2, if cell I2 is greater than 2 minutes but less than two minutes, the I need the value of I2 in Cell J2 otherwise 0:00:00 then K2 between 3 & 4 Mins and so on.
Help is appreciated.
Om
Hi all, if you look at attachment, in Cell J2, if cell I2 is greater than 2 minutes but less than two minutes, the I need the value of I2 in Cell J2 otherwise 0:00:00 then K2 between 3 & 4 Mins and so on.
Help is appreciated.
Om
Last edited by omletto; 02-09-2010 at 11:04 AM.
[QUOTE=omletto;2249931if cell I2 is greater than 2 minutes but less than two minutes
Om[/QUOTE]
is it possible to be greater than 2 but less than 2????
Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Sorry, More than 2mins but less than 3 mins.
Try this formula in J2, format as time and then copy across and down as required
=($I2>=J$1)*($I2<J$1+"0:01")*$I2
Look here:
(If you like empty cell rather than 0:00:00 then change
=IF(AND($I2>=IF(ISTEXT(I$1);0;I$1);$I2<J$1);$I2;1*"0:00:00")
into
=IF(AND($I2>=IF(ISTEXT(I$1);0;I$1);$I2<J$1);$I2;"")
Difference to daddylonglegs is that you can define different time in top of each header.
If you have always same difference use solution as daddylonglegs showed.
Last edited by zbor; 02-09-2010 at 11:03 AM.
Thanks both, worked perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks