Donate SIGN UP

Excel for work hours

Avatar Image
DC_FC | 16:48 Thu 24th May 2012 | Computers
7 Answers
I use excel to keep track of what hours i do at work but is there an easier to copy/transpose all the dates etc from 1 sheet to another ? At the minute i just type out the days and do the calculations.
Gravatar

Answers

1 to 7 of 7rss feed

Best Answer

No best answer has yet been selected by DC_FC. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
If the dates are all in one column then select the entire column then cut and paste to the new sheet.
If you type in the first couple of dates, highlight the cells then drag down from the bottom left-hand corner it will infill the calendar dates for you.........
Just in case I have misunderstood can you describe the layout of the sheet in more detail.
Sorry bottom right -hand corner........
Question Author
The way i have it set up is that each sheet in excel is for each month and i have the dates for example monday to saturday for week 1 in row 1 then week 2 in row 6 etc etc.
type 1 in Cell A1

Type Mon, Tues or whatever the first day is into Cell B1

Select them both and click on the black square in bottom right.

Still holding the mouse on the square, drag down for 31 or whatever number of days there are in the month.

Sorry if this is a bit simplistic, but your problem isn't very advanced stuff..
Question Author
Thanks for your replies, venator your solution was what i was kind of after except i have a row for each week but ill give your solution a go

1 to 7 of 7rss feed

Do you know the answer?

Excel for work hours

Answer Question >>