Further to the above discussion, I have some more issues that need resolving, mainly around the IF statement. What I am trying to do is tell the code to look at the cell, see if its after 23:00 and before 07:00 and if it is copy the cell next to it. I just can't resolve this logical test. Any help? 
Sub Macro2() '
     'If Col A between times , then copy B to C
     
    Dim StartTime As Double 
    Dim EndTime As Double 
    Dim r As Long 
     
    StartTime = TimeSerial(23, 0, 0) 
    EndTime = TimeSerial(7, 0, 0) 
     
    For r = 2 To Cells(Rows.Count, "A").End(xlUp).Row 
        With Cells(r, "A") 
            If .Value >= StartTime And .Value <= EndTime Then _ 
            Cells(r, "C") = Cells(r, "B") 
             'Alternate Cells(r, "B").Copy Cells(r, "C")
        End With 
    Next r 
End Sub
although i've only been coding a few weeks and generally have no clue at all!
I've been doing this for 13 years.