Poll

Aboot this blog

This blog is a cross between a scrapbook and a diary. I hope you find something here of interest. If you’d like to keep up with things as I see them then you can subscribe to my news feed by clicking the icon below:

feed-icon-28x28.png

DISCLAIMER

Please note that any reviews/recommendations are based solely on my own experience and does not constitute a guarantee that you will have the same experience. Please do your own research before parting with any money - the risk is all yours!

The Briticiser

Looking for my world famous US to GB English spelling converter?

THE “BRITICIZSER”

www.us2uk.eu

IT’S HERE

Tags

  Bookmarks     3D Stuff     Family     Equipment     Utilities     Tutorials     Windows     VBA     Hardware     Plausible Lies     News     Education         Acrobat     Overcoming Disabilities     Software     Excel     Reviews     Bits and Bobs     PHP     Browsers     Word     Odds and Sods     Flatpress  

Find me on Facebook

facebook-icon-28x28.pngVisit my Briticiser Facebook Page to keep up with things here - lots of reviews of stuff I’ve really used and also all kinds of helpful computer tips with a heavy bias towards SAVING YOU TIME.

Task Time Counter

Permalink: http://paul.us2uk.eu/?x=entry:entry141205-170816

If you frequently switch between one job or project and another then this Task Time Counter which runs in Excel might be just what you’re looking for.

It’s very simple to use - just click on the Switch Task button to bring up your list of jobs and select one by clicking on the drop down arrow.

image

As soon as you make a selection the current date and time will be entered as the stop time of the previous task, and the start time of the current one.

image Note that a little bit of security has been applied here (to help avoid you doing something which might screw the whole thing up) - making a new selection will protect the spreadsheet (and save it for you) but, if you find that you need to change the time on an entry then simply unlock the spreadsheet (Alt+T followed by P followed by another P is the way I do that quickly) and make your change. You can lock the spreadsheet manually again - if you want - but it will lock automatically anyway, as soon as you switch tasks again, so there’s really no need to.

Adding a new job is just as easy. You can either click the “Add” button at the top of the spreadsheet, or click the “+” button on the task switching form. Either of these actions will bring up a form where you can enter your new job details:

image

Click “Save & Continue” when you’ve entered your details and the new job will be available to select in the task switching form drop down list:

image

Note here that any new job will always appear in 5th place in the list, so you can have some frequently recurring jobs (such as “General” or “Clock Off”) always showing, and then have your most recent jobs appear after those.

If you want to switch the positions around a bit, then go into the 2nd sheet (”Projects List”) on the Workbook and move the rows around as you wish.

This is very basic and a little rough around the edges - but I’ve used it now for about 3 years and have a shortcut to it sat in my Programs>Startup folder, so it pops up for me to choose my first job of the day as soon as I start my computer up on a morning… and it’s the last thing I use before I turn it off again when I’ve finished working for the day.

I hope this is of use to a few other people - please remember that it does use macros so you need to save this workbook in a trusted location (Windows 7) or know how to fiddle with your Excel security setting enough to enable macros to run.

You can download it here:

By downloading and using this spreadsheet you agree to take responsibility for it - it becomes yours for you to learn from and adapt however you want. Due to time constraints I may or may not be able to help you if you hit a problem with it - but you can always try sending me a message via my contact page.

Good luck!

Support our caregiving

If you found anything on this site of use, interesting, or even mildly amusing then please consider dropping a few pennies in the jar to help us to take care of our disabled son who contracted encephalitis in 2007 at the age of 6 and who is now confined to a wheelchair. He is getting bigger as his mother and I get older, imagine that, please. Every penny we collect goes towards his upkeep, and towards his future care requirements.

Thank you.

Support our caregiving

Support our caregiving

If you found anything on this site of use, interesting, or even mildly amusing then please consider dropping a few pennies in the jar to help us to take care of our disabled son who contracted encephalitis in 2007 at the age of 6 and who is now confined to a wheelchair. He is getting bigger as his mother and I get older, imagine that, please. Every penny we collect goes towards his upkeep, and towards his future care requirements.

Thank you.