Hi

I have a list of custom format date and time value in column "A" which occurs over a five month period ( 00/00/0000 00:00:00). i have the date of the sunrise/sunset in column "B" and the time of the sunrise in column C and the sunset time in column D.

I am wanting to have a column which uses the sunrise/sunset times to separate "night" and "day". So that i can analysis the night values separate to the day values. I could probably use pivot table to do the analysis but i need to assign the day and night value first.

has any one as got any idea , completely lost with this one

Cheers