Hi Jenn,

Yes, each time field now has an IF field to test whether there are data and a formula to convert such data into something that looks like a time. you should be able to just copy the field code from any of those to your 'lights on' and 'lights off' cells and change the mergefield references.

If your data do in fact all have the same header/footer when filtered, there shouldn't be any need to modify the page layout. It was when I did a simple merge with all records that I noticed that they changed.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]