software

Hiya guys and gals

I have the following piece of code;

=IF((E$2gt;=$B6)*(E$2lt;=$D6),1,)

Cells E2:AZ2 contain time (00:30,01:30,02:00 and so on)

So the code will work as follows, if E2 is greater than or equal to B6,
an employees start time, but less than or equal to D6, an employees
finish time, then current cell =1.

Now this works fine from 03:00 onwards, but before this time it seems
to take away thirty mins. For example if an employees start time is
02:00 the first quot;1quot; will be in the 02:30 box! Like i said after 03:00
the program works perfectly i just cannot seem to understand what the
problem is.

Any help will be greatly appriciated.

Cheers

James--
superkopite
------------------------------------------------------------------------
superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=514073
Hello James,

E-mail your workbook and let me see what you did.

Sincerely,
Leith--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: www.excelforum.com/member.php...oamp;userid=18465
View this thread: www.excelforum.com/showthread...hreadid=514073
Hi Leith

Just mailed it

Many Thanks

James--
superkopite
------------------------------------------------------------------------
superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=514073Hi

Try re-typing the value 2:00 in cell H2
I can re-create your problem if I type 1:59:59.59 in H2. It displays as
2:00 but obviously it's internal value is less than 2:00 hence the test
fails.

--
Regards

Roger Govierquot;superkopitequot; gt;
wrote in message
...
gt;
gt; Hiya guys and gals
gt;
gt; I have the following piece of code;
gt;
gt; =IF((E$2gt;=$B6)*(E$2lt;=$D6),1,)
gt;
gt; Cells E2:AZ2 contain time (00:30,01:30,02:00 and so on)
gt;
gt; So the code will work as follows, if E2 is greater than or equal to
gt; B6,
gt; an employees start time, but less than or equal to D6, an employees
gt; finish time, then current cell =1.
gt;
gt; Now this works fine from 03:00 onwards, but before this time it seems
gt; to take away thirty mins. For example if an employees start time is
gt; 02:00 the first quot;1quot; will be in the 02:30 box! Like i said after 03:00
gt; the program works perfectly i just cannot seem to understand what the
gt; problem is.
gt;
gt; Any help will be greatly appriciated.
gt;
gt; Cheers
gt;
gt; James
gt;
gt;
gt; --
gt; superkopite
gt; ------------------------------------------------------------------------
gt; superkopite's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29496
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=514073
gt;