Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Creating ad-hoc timesheets using the time Excel 2010 is opened/closed

16 Mar 2013   #1

Windows 7 64bit
Creating ad-hoc timesheets using the time Excel 2010 is opened/closed

I am looking to create a timesheet so that I can track my work time on various projects and be able to create accurate records using Excel 2010.

I have had a look around online and have found various templates and tutorials, but none of them are quite what I am looking for. (I'm also not entirely sure what I am looking for is possible.)

The work I am doing will be ad-hoc (potentially: a couple of sessions within one 24 hour day; regular daily sessions of varying lengths; 1-2 days inbetween sessions when I do not work on the project) so I do not need the Mon-Fri/Sun layout that most timesheet templates online offer, and as the hours are my own and unscheduled, I do not need the options for overtime/lunch/sick leave etc.

Ideally, the spreadsheet I would like to set up would be able to enter the time automatically when opened and closed, meaning that I would open the excel sheet before working and close it when my session was done. I have little experience with Excel comments and functions, but I think there is a function =NOW or =DATE (or similar) that updates automatically when opened. This is ideal, but it would need to be fixed once updated, so that it didn't update itself again when the file is next opened.

I would also need to be able to convert units in hours to units that can be multiplied by my hourly rate for the final cost. (I have found this tutorial on creating time sheets, but although I followed the instructions carefully, I ended up with a total of 1.36, and not 32.75.)

I'm not sure if this is possible, and (thinking it through) I'm pretty sure it would take some general admin to the form that would be the equivalent of just inputting the time manually, but I thought I would try and find out if there was a solution that met my idea first.

I understand that I am asking a lot, and I hope I have explained what I am looking for clearly enough for you to help me. Any and all suggestions, comments or tutorials/website links etc. are appreciated.

Thank you in advance.

My System SpecsSystem Spec


 Creating ad-hoc timesheets using the time Excel 2010 is opened/closed

Thread Tools

Similar help and support threads for2: Creating ad-hoc timesheets using the time Excel 2010 is opened/closed
Thread Forum
Solved Excel 2010, acting sluggish and taking 3-15 min at a time for change. Microsoft Office
Creating a Task in Outlook 2010 from a Word 2010 Document Microsoft Office
Search results in Outlook 2010 cannot be closed Microsoft Office
Word-2010 Taking 100% CPU even after I closed the document Microsoft Office
Windows 7 SP1 Can Crash If Command Prompt Is Opened and Closed Windows Updates & Activation
Formatting Excel 2010, Excel 2003 Microsoft Office
Office 2010 Excel when opened says library object is missing Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 06:09 PM.
Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33