2013

=IF(AND(HOUR(C2)>=0;HOUR(C2)<1);"Midnight";IF(AND(HOUR(C2)>=1;HOUR(C2)<2);"One";IF(AND(HOUR(C2)>=2;HOUR(C2)<3);"Two";IF(AND(HOUR(C2)>=3;HOUR(C2)<4);"Three";IF(AND(HOUR(C2)>=4;HOUR(C2)<5);"Four";IF(AND(HOUR(C2)>=5;HOUR(C2)<6);"Five";IF(AND(HOUR(C2)>=6;HOUR(C2)<7);"Six";IF(AND(HOUR(C2)>=7;HOUR(C2)<8);"Seven";IF(AND(HOUR(C2)>=8;HOUR(C2)<9);"Eight";IF(AND(HOUR(C2)>=9;HOUR(C2)<10);"Nine";IF(AND(HOUR(C2)>=10;HOUR(C2)<11);"Ten";IF(AND(HOUR(C2)>=11;HOUR(C2)<12);"Eleven";IF(AND(HOUR(C2)>=12;HOUR(C2)<13);"Midday";IF(AND(HOUR(C2)>=13;HOUR(C2)<14);"thirteen";IF(AND(HOUR(C2)>=14;HOUR(C2)<15);"Fourteen";IF(AND(HOUR(C2)>=15;HOUR(C2)<16);"Fifteen";IF(AND(HOUR(C2)>=16;HOUR(C2)<17);"Seexteen";IF(AND(HOUR(C2)>=17;HOUR(C2)<18);"Seventeen";IF(AND(HOUR(C2)>=18;HOUR(C2)<19);"Eighteen";IF(AND(HOUR(C2)>=19;HOUR(C2)<20);"Nineteen";IF(AND(HOUR(C2)>=20;HOUR(C2)<21);"Twenty";IF(AND(HOUR(C2)>=21;HOUR(C2)<22);"Twenty one";IF(AND(HOUR(C2)>=22;HOUR(C2)<23);"Twenty two";IF(AND(HOUR(C2)>=23;HOUR(C2)<24);"Twenty three"))))))))))))))))))))))))

yupiiiiiiiiii!!!!!!!!!!!!!!!!!!!!

> aggregate(Cow ~ Hora, data=esther, sum)

         Hora Cow

1       Eight 176

2    Eighteen  79

3      Eleven  87

4       FALSE   2

5     Fifteen  39

6        Five   6

7        Four   6

8    Fourteen  13

9      Midday 108

10   Midnight   2

11       Nine  31

12   Nineteen  69

13   Seexteen  38

14      Seven 209

15  Seventeen  63

16        Six  59

17        Ten  21

18   thirteen  26

19      Three   4

20     Twenty 119

21 Twenty one  64

22 Twenty two   8

23        Two  18

Efectivamente, aún hay algún error, pero ahora mismo no me importa! A comeeer!