Time tracking using a description, can it be done?

  • Hello everyone,

    We use a time tracking program at work.

    This program has a very low timeout setting, (around 2 or 3 minutes), causing me to logon several times to complete a timesheet.

    I created a spreadsheet similar to the one attached, it has a total hrs of 40 and a remaining hrs (basically Cell D1 starts at 40hrs and when a number is entered in the hours column that number is subtracted from 40 leaving the hours remaining).

    My problem: I also have a set amount of time I can enter for my projects (budget reasons) in the sample I've put in cell G5 the number 26, I need a formula that will subtract from 26 the hours that has a particular description, in my sample I using Description 2.

    When the Text Description 2 is enter in the C column, the corresponding hours should be subtracted from G5. In my sample, B3, B5, B6, and B9 should be subtracted from G5.

    Hope I've provided enought Information.

    Thanks in advance for your help.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!