Results 1 to 16 of 16

Automating a time sheet

Threaded View

  1. #1
    Registered User
    Join Date
    01-17-2013
    Location
    Virginia
    MS-Off Ver
    Excel 2010
    Posts
    14

    Automating a time sheet

    I have a timesheet that secretaries need automated. Basically, they need the first Start time for the date in Column B compared to the time in cell D9. If that time is 15, 30, 45 or an hour later than the time in D9, then it need to be counted in the table to the left of the data. It also need to be based on the month. For example, if John Doe was 15 minutes late 3 times in December, then in the table I would need the number 3 in J18.

    I'm uploading the spreadsheet. Any ideas to help guide me or even the code to completely do what is requested would be greatly appreciated. Thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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