excel timesheet nerd

I didn't know about Ctrl-Shift-Colon.?ÿ I don't know if I'll use it much, but it's nice to know.?ÿ (Note that it also works with LibreOffice Calc, which I use instead of Excel.)

I LOVE?ÿ my excel time sheet, mine does similarly to .5 hr with drop downs for projects and tasks love me some nerd work.

?ÿ

RRain

Would someone be willing to post an example with the timestamp?

TIME STAMP IS AN EXCELL FEATURE WHICH WILL POPULATE THE CURRENT CELL WITH THE CURRENT TIME WHEN EXECUTED (HOLD CTL + SHIFT?ÿ AND HIT ;).

DATE STAMP WORKS WELL ALSO (CTL + 😉

IN MY SHEET THE TIME STAMP GOES INTO THE SMALL CELL TO THE LEFT OF THE START TIME COLUMN THEN TAB TWICE FOR END TIME.

?ÿ

My excel timesheet I would just type in 0.25

Not sure why the time I started and finished would be important. Please enlighten me! I am all for over-nerdifying my excel spreadsheets!

Andy, good stuff!!?ÿ I went a little nuts with it and made the attached weekly sheet.?ÿ For the date just hit "cntl + ;" and the sheet fills in the date and do as Andy pointed out for the time slots otherwise enter time as Zulu time.?ÿ Once you enter a date the sheet color codes the hours and totals them by day at the bottom, this let the sheet be narrower than what we were using.

?ÿ I did round to the nearest 0.5 hour though (its a quick change)

Posted by: ppm

My excel timesheet I would just type in 0.25

Not sure why the time I started and finished would be important. Please enlighten me! I am all for over-nerdifying my excel spreadsheets!

i like it as a way to track my time... I'm terrible at timesheets, but somehow using excel keeps me somewhat current.?ÿ i never tracked a minute of time for 12 years so having to do this at the new gig has been a struggle!?ÿ?ÿ

Randy,?ÿ

?ÿ

Love that!?ÿ and the Vlookup table is where I'm headed too.?ÿ ?ÿmy problem is a 30+ year database with mostly good info, but LOTS of holes.?ÿ?ÿ

Posted by: Norm Larson

Andy, good stuff!!?ÿ I went a little nuts with it and made the attached weekly sheet.?ÿ For the date just hit "cntl + ;" and the sheet fills in the date and do as Andy pointed out for the time slots otherwise enter time as Zulu time.?ÿ Once you enter a date the sheet color codes the hours and totals them by day at the bottom, this let the sheet be narrower than what we were using.

Attachment : Weekly time sht.xlsx

?ÿ I did round to the nearest 0.5 hour though (its a quick change)

Very cool, Norm!?ÿ ?ÿI like that !?ÿ I need to review how to attach a file, I crashed when I tried to add my example file.?ÿ?ÿ

?ÿ

I think this worked!?ÿ Thanks @Wendell for the FAQ tutorial!?ÿ ?ÿ

?ÿ

I have an exta sheet in there in case I get a lot done in a week

I also have a sheet for frequently used billing codes

Finally, I use the "LOG" sheet to track my phone calls and general "to do" items.?ÿ ?ÿ ?ÿ

?ÿ

in the View tab, if you go to "page layout" that is what I print for the timesheet to hand in.?ÿ That works for now, but I wish it automatically uploaded into the system..?ÿ one step at a time, grasshopper.?ÿ?ÿ

My pleasure! (although I had to go look in the Support section to remind myself of what I did) LOL 😀

Andy, I revised my sheet because it occurred to me last night that if you subtract a rounded number from a rounded number you are going to not have things add up to total correctly.?ÿ So for the individual "charging" hours I have changed the rounding too "=(MROUND((D23-C23),"0:15"))*24" for your example.?ÿ I changed the sheet to total charging hours as well as hours based upon the actual non rounded time (which is then rounded at the very end).?ÿ Now I truly feel I have beaten my version to death ...

?ÿ I also copied the base sheet into several other sheets within the xlsx so that it could be used for a month.

in the View tab, if you go to "page layout" that is what I print for the timesheet to hand in.?ÿ That works for now, but I wish it automatically uploaded into the system..?ÿ one step at a time, grasshopper.?ÿ?ÿ

When I made my GPS reduction sheet that goes from Carlson to Trimble, I made the calc sheet just as I needed it to analyze the data and then I took sheet 2 (the one in the lower left of sheet 1 on the xlsx) and had it insert the final data into cells made for export in the format necessary.?ÿ Then it is a simple as exporting from sheet two the data in the proper format.?ÿ The GPS sheet that I did has the data as well as co variance matrix's and all of the data that the ASCII ".dc" format needs.?ÿ It was the best way that I found .. It was the only way that I found of exporting in the proper format