me needs some reminding (ms excel) - Page 2

jimhelm · 04-30-2011, 02:35 PM

LOOKS LIKE THIS:

HungLikeJesus · 04-30-2011, 04:39 PM

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

BigV · 05-05-2011, 12:21 PM

just use julian time

plthijinx · 05-05-2011, 06:42 PM

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......

skysidhe · 05-05-2011, 09:41 PM

Insert > picture> browse location

My apologies if I misunderstood the question, again.

HungLikeJesus · 05-06-2011, 07:19 AM

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.

plthijinx · 05-08-2011, 10:17 AM

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.

plthijinx · 05-08-2011, 11:38 PM

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

HungLikeJesus · 05-09-2011, 07:31 AM

Looks good. I like your use of color.

plthijinx · 05-09-2011, 11:42 AM

Quote:

Originally Posted by HungLikeJesus

Looks good. I like your use of color.

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

jimhelm · 05-09-2011, 11:44 AM

Quote:

Originally Posted by HungLikeJesus

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

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

04-30-2011, 02:35 PM	#16
jimhelm a beautiful fool Join Date: Sep 2010 Location: 39.939705 Posts: 4,504	LOOKS LIKE THIS: Attached Images __________________ There's a Shadow just behind me. Shrouding every step I take. Making every promise empty, pointing every finger at me. _tool

04-30-2011, 04:39 PM	#17
HungLikeJesus Only looks like a disaster tourist Join Date: Feb 2007 Location: above 7,000 feet Posts: 7,208	What happens if you put in a shift that runs beyond midnight (e.g. 1 PM to 1 AM)? __________________ Keep Your Bodies Off My Lawn SteveDallas's Random Thread Picker.

05-05-2011, 12:21 PM	#18
BigV Goon Squad Leader Join Date: Nov 2004 Location: Seattle Posts: 27,063	just use julian time __________________ Be Just and Fear Not.

05-05-2011, 06:42 PM	#19
plthijinx Master Dwellar Join Date: Aug 2003 Posts: 4,197	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...... __________________ For your dreams to come true, you must first have a dream.

05-06-2011, 07:19 AM	#21
HungLikeJesus Only looks like a disaster tourist Join Date: Feb 2007 Location: above 7,000 feet Posts: 7,208	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. __________________ Keep Your Bodies Off My Lawn SteveDallas's Random Thread Picker.

05-05-2011, 09:41 PM	#20
skysidhe ~~Life is either a daring adventure or nothing.~~ Join Date: Apr 2006 Posts: 6,828	Insert > picture> browse location My apologies if I misunderstood the question, again.

05-08-2011, 10:17 AM	#22
plthijinx Master Dwellar Join Date: Aug 2003 Posts: 4,197	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. __________________ For your dreams to come true, you must first have a dream.

05-08-2011, 11:38 PM	#23
plthijinx Master Dwellar Join Date: Aug 2003 Posts: 4,197	here is the tweaked version. again thank you for all the help!!! this is exactly what i wanted! Attached Images __________________ For your dreams to come true, you must first have a dream.

05-09-2011, 07:31 AM	#24
HungLikeJesus Only looks like a disaster tourist Join Date: Feb 2007 Location: above 7,000 feet Posts: 7,208	Looks good. I like your use of color. __________________ Keep Your Bodies Off My Lawn SteveDallas's Random Thread Picker.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)