+ Reply to Thread
Results 1 to 2 of 2

Formulas for a unique timesheet

  1. #1
    Registered User
    Join Date
    12-16-2015
    Location
    Atlanta
    MS-Off Ver
    2010
    Posts
    1

    Formulas for a unique timesheet

    I previously created a timesheet for myself that allowed me to add tasks throughout the day with the amount of time used for that task. It would automatically add to a cell that kept the overall time of day accounted for. In other words, if I started on a task at 8am and worked until 8:40, I would add .7 to the task (equal to 42 minutes) and the cell at the top would now say 8:42am.

    The reason this approach was helpful to me was it helped me account for every minute during the day. If I checked the sheet at 9:30am (actual time), but the sheet said 8:42am, I know I had to account for those 48 minutes with which tasks I was just working on.

    Unfortunately, I have lost that time sheet and am struggling to find the right formulas to get it working again.

    Here is an example of what I am trying to build... and what I have been able to reconstruct: http://screencast.com/t/dGwQTZeMqXsB

    Thanks in advance for your help! This can be done... I just can't remember how I originally did it.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,748

    Re: Formulas for a unique timesheet

    Hi, welcome to the forum

    Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
    Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

    Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Timesheet Formulas
    By Lord Byron in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 12-16-2013, 10:48 AM
  2. [SOLVED] Timesheet formulas that include leave entitlements
    By beitzy in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 11-22-2013, 08:53 PM
  3. Formulas for input rules of a timesheet submission
    By mr_vic in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-24-2013, 02:53 AM
  4. Formulas for calculating timesheet
    By Val C in forum Excel General
    Replies: 4
    Last Post: 05-25-2010, 07:31 AM
  5. Semi Monthly Timesheet, need help with formulas
    By WG Security in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-21-2008, 06:18 PM
  6. Formulas for timesheet
    By draftedsolution in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-30-2007, 04:11 AM
  7. [SOLVED] Timesheet formulas
    By Doug in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-03-2005, 04:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1