+ Reply to Thread
Results 1 to 4 of 4

Time Sheet Problems

  1. #1
    Registered User
    Join Date
    10-23-2019
    Location
    OHIO
    MS-Off Ver
    office 2013
    Posts
    81

    Time Sheet Problems

    Hi All,

    as you can tell i am fairly new and learning but...

    I have tried to build a basic time sheet calculator but ive run into problems with betting the times to calculate correctly, as you can see from the attached file (link below)

    https://www.dropbox.com/s/j6ubmuqs07...temp.xlsx?dl=0

    The "hours worked" boxes do add up the clock on and clock off figures fine but the sub total box and total box will not add them up correctly?

    obviously i have done something wrong but i cant figure out what??



    On a related note:
    I have also created a simple vba button that populates the selected cell with the current time but is it possible to make the cell locked so that time cant be edited once inserted and for the button to automatically move in this sequence:
    b9 b1 c9 c10 d9 d10 e9 e10 f9 f10 g9 g10 h9 h10 ?

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,786

    Re: Time Sheet Problems

    Hi,

    Would you upload the file to this forum please.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    10-23-2019
    Location
    OHIO
    MS-Off Ver
    office 2013
    Posts
    81

    Re: Time Sheet Problems

    Hi Richard, i have tried but cant seem to see how?

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,134

    Re: Time Sheet Problems

    follow the instructions in the yellow banner at the top of the post AND make sure to include expected results.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

+ 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. Time sheet problems
    By CharlesKnigh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-23-2018, 06:48 AM
  2. Time sheet problems
    By CharlesKnigh in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-12-2018, 03:50 AM
  3. Replies: 2
    Last Post: 07-22-2014, 09:20 AM
  4. Having problems with formatting time in a time sheet
    By cptrosakelly in forum Excel General
    Replies: 4
    Last Post: 01-07-2014, 06:12 PM
  5. Problems creating a time macro that moves data from one sheet to another.
    By Sanorah in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-23-2012, 08:27 AM
  6. Time sheet Problems
    By jeff dorlaque in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2012, 04:04 PM
  7. [SOLVED] Am trying to make a time sheet and having problems with a formula.
    By godnight in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-14-2005, 10:06 AM

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