+ Reply to Thread
Results 1 to 7 of 7

Time Sheet Calculator

  1. #1
    Registered User
    Join Date
    04-05-2016
    Location
    Karachi, Pakistan
    MS-Off Ver
    2013
    Posts
    3

    Arrow Time Sheet Calculator

    Sheet.jpg

    I have attached a picture for you guys.
    I am accountant in a small business.
    As you can see in the image I have double Arrival & Exit timing.
    I have double it because if an employee goes out for any kind of personal work he will write exit time on his sheet if he returns on the same day he will write arrival timing and when his duty duration is finished he will write exit.
    Now let's get on point I wanted to use such kind of formula that I would be able to just write timings, and the late minutes column & overtime column will show the late minutes and over time minutes by formula.
    If any employee is late more than 15 minutes his timing will be written in late minutes column.
    Usually total employee working minutes in my company is 540 min per day if he gives more than 540 minuter in my company it will be considered overtime.
    Kindly help me if you can.
    I am little weak in VBA but if you would help me I would be able do something or it could be done without vba.
    Tell me about the format if you understand it or not.

  2. #2
    Forum Contributor Toonies's Avatar
    Join Date
    07-30-2009
    Location
    Newcastle, UK
    MS-Off Ver
    Excel 2016
    Posts
    492

    Re: Time Sheet Calculator

    try this it should do what you need

    I've uploaded an example, however it will not let me place example formula's in this text area for some reason

    So I have placed copies on example sheet
    Attached Files Attached Files
    Last edited by Toonies; 04-05-2016 at 11:41 AM.

  3. #3
    Forum Contributor Toonies's Avatar
    Join Date
    07-30-2009
    Location
    Newcastle, UK
    MS-Off Ver
    Excel 2016
    Posts
    492

    Re: Time Sheet Calculator

    here is a VBA Solution (A Guru on here wrote the original code) I take no credit for this

    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    04-05-2016
    Location
    Karachi, Pakistan
    MS-Off Ver
    2013
    Posts
    3

    Re: Time Sheet Calculator

    Thanks.
    Can I use any kind of formula for late minutes.
    If a employee reaches office at 9:15 he will not be considered late but if he reaches office at 9:16 he will be considered late.
    And the late minutes column will show 16 min late.

  5. #5
    Forum Contributor Toonies's Avatar
    Join Date
    07-30-2009
    Location
    Newcastle, UK
    MS-Off Ver
    Excel 2016
    Posts
    492

    Re: Time Sheet Calculator

    I have added your requirements to your sheets.

    if more than 15 minute late the the text in the late cell turns red and underlined.

    Non VBA Revised

    VBA Example Revised
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    04-05-2016
    Location
    Karachi, Pakistan
    MS-Off Ver
    2013
    Posts
    3

    Re: Time Sheet Calculator

    Thanks Mr.Toonies
    You helped me a lot.

  7. #7
    Forum Contributor Toonies's Avatar
    Join Date
    07-30-2009
    Location
    Newcastle, UK
    MS-Off Ver
    Excel 2016
    Posts
    492

    Re: Time Sheet Calculator

    Glad I could help, don't forget to mark thread as solved

+ 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] Time Code Calculator 30fps - Mac
    By sunrhat in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 13
    Last Post: 05-16-2015, 09:00 PM
  2. [SOLVED] need a formula for entering hour numbers in time sheet calculator
    By tecnico in forum Excel Formulas & Functions
    Replies: 30
    Last Post: 05-07-2013, 01:02 PM
  3. Replies: 8
    Last Post: 04-23-2013, 03:43 AM
  4. How to Develop a Break Time Calculator with Buttons
    By vrindamithul in forum Excel General
    Replies: 0
    Last Post: 02-10-2013, 07:32 AM
  5. Time calculator
    By coolhit in forum Excel General
    Replies: 5
    Last Post: 12-02-2012, 06:08 AM
  6. UK Post Code Calculator - Time
    By trashcanit in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2012, 08:45 AM
  7. Excel 2007 : Time range calculator?
    By SPEKTRE76 in forum Excel General
    Replies: 2
    Last Post: 09-21-2009, 02:08 PM
  8. Flexitime / Work time calculator
    By Fluxcapacitorrr in forum Excel General
    Replies: 3
    Last Post: 10-02-2007, 06:43 AM

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