LOOKS LIKE THIS:

What happens if you put in a shift that runs beyond midnight (e.g. 1 PM to 1 AM)?

just use julian time

yeah, the file that HLJ sent me works just how i want. all i did was hide the daily total columns then i'm going to tweak it a little more.

new question:

msword. is there a way to print to a jpeg file? i know you can print to jpeg but it's been so dang long since i've worked with it so much has changed. kinda the same problem i had with excel......

Insert > picture> browse location

My apologies if I misunderstood the question, again.:blush:

If it's just a page or two you could do an alt-"print screen" and then paste back into a new document and crop out the extra part. (Or, if you're using Vista or newer, there's a snipping tool that lets you grab whatever part of the screen you want.)

You can also select print and print to a PDF (I don't know if that's included with Word, or if you have to have Adobe Writer/Pro).

Another option is to print to the XPS Document Writer.

yeah i did the print screen option. i did it's job. basically the GM at work had a logo for his pool league t-shirts and the printer needed a jpeg rather than the word file.

oh, and another thing, i've finished the time sheet. will post it later today or tomorrow. whenever i get the chance. most likely tomorrow.

here is the tweaked version. again thank you for all the help!!! this is exactly what i wanted!

Looks good. I like your use of color.

ty, makes it easier to read and follow. easy contrast to the eyes....

then you have to rewrite the code and it takes like twice as long. he talks about it in that video.