software

Hi All,

I'm hoping this will be an easy answer, heres my query...

00:01 - 12:00 = 1, 12:01 - 18:00 = 2, etc etc

A B
12:45 2
11:41 1
00:25 1
13:15 2
14:54 2

Now from the criteria above I would like column B to show 1's amp; 2's etc etc.

Any ideas guys??

Thanks,
James.

Try:

Hours are divide by 24 to get Excel representation i.e 24 hours 1.0, 12
hours=0.5

=IF(A2gt;(18/24),3,IF(A2gt;(12/24),2,1))

HTH

quot;Jamesyquot; wrote:

gt; Hi All,
gt;
gt; I'm hoping this will be an easy answer, heres my query...
gt;
gt; 00:01 - 12:00 = 1, 12:01 - 18:00 = 2, etc etc
gt;
gt; A B
gt; 12:45 2
gt; 11:41 1
gt; 00:25 1
gt; 13:15 2
gt; 14:54 2
gt;
gt; Now from the criteria above I would like column B to show 1's amp; 2's etc etc.
gt;
gt; Any ideas guys??
gt;
gt; Thanks,
gt; James.

Toppers you legend!

Quality stuff, thanks a bunch!

quot;Toppersquot; wrote:

gt; Try:
gt;
gt; Hours are divide by 24 to get Excel representation i.e 24 hours 1.0, 12
gt; hours=0.5
gt;
gt; =IF(A2gt;(18/24),3,IF(A2gt;(12/24),2,1))
gt;
gt; HTH
gt;
gt; quot;Jamesyquot; wrote:
gt;
gt; gt; Hi All,
gt; gt;
gt; gt; I'm hoping this will be an easy answer, heres my query...
gt; gt;
gt; gt; 00:01 - 12:00 = 1, 12:01 - 18:00 = 2, etc etc
gt; gt;
gt; gt; A B
gt; gt; 12:45 2
gt; gt; 11:41 1
gt; gt; 00:25 1
gt; gt; 13:15 2
gt; gt; 14:54 2
gt; gt;
gt; gt; Now from the criteria above I would like column B to show 1's amp; 2's etc etc.
gt; gt;
gt; gt; Any ideas guys??
gt; gt;
gt; gt; Thanks,
gt; gt; James.