How to Calculate the Employee TimeSheet

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Serenityquinn15
    New Member
    • Oct 2007
    • 30

    How to Calculate the Employee TimeSheet

    Hi!

    I just want to know, how to calculate the employee timesheet it's a part of payroll system. and it is my first time to create a system like this. I need to determine the Overtime, Late and undertime of each employee, Please Help me...


    Thanks.... :)
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    What exactly are you developing?
    Does it involve any database, if so what is the database?
    Kindly pass a few more details.

    How do you expect us to suggest anything without having any knowledge of what is happening on your side?
    Last edited by Killer42; Dec 18 '07, 07:43 AM.

    Comment

    • Killer42
      Recognized Expert Expert
      • Oct 2006
      • 8429

      #3
      TheScripts may not be the best site for this sort of question. We're geared more toward helping with programming problems while building software, not designing the software in the first place.

      On the other hand, of course, you might get lucky.

      Comment

      • Serenityquinn15
        New Member
        • Oct 2007
        • 30

        #4
        Originally posted by debasisdas
        What exactly are you developing?
        Does it involve any database, if so what is the database?
        Kindly pass a few more details.

        How do you expect us to suggest anything without having any knowledge of what is happening on your side?
        Yes, it is involve in my database, I'm using MS Access database.
        The interface that I'm using is Visual Basic 6.0, can you please give me some sample of code to compute the total of minutes?
        Here is the example:

        TimeIN : 8:00 am
        TimeOut: 17:00 pm

        What I really need is the code to compute the total of minutes per day.

        I know how to compute it in Excel, but not in VB code. I'm a new beginner, and I'm very interested in Visual Basic.

        Thanks.
        Last edited by Killer42; Dec 19 '07, 02:03 AM.

        Comment

        • lotus18
          Contributor
          • Nov 2007
          • 865

          #5
          Hi

          If you want to get the total no. of minutes of the two, you can use the DateDiff function.

          e.g.

          [CODE=vb]
          Dim total As String
          Dim timein As Date, timeout As Date
          timein = #8:00:00 AM#
          timeout = #5:00:00 PM#

          total = DateDiff("n", timein, timeout)[/CODE]

          Rey Sean
          Last edited by lotus18; Dec 19 '07, 01:33 AM. Reason: code tag added

          Comment

          • Serenityquinn15
            New Member
            • Oct 2007
            • 30

            #6
            Originally posted by lotus18
            Hi

            If you want to get the total no. of minutes of the two, you can use the DateDiff function.

            e.g.

            [CODE=vb]
            Dim total As String
            Dim timein As Date, timeout As Date
            timein = #8:00:00 AM#
            timeout = #5:00:00 PM#

            total = DateDiff("n", timein, timeout)[/CODE]

            Rey Sean
            thanks for your help....
            one more question, in time we use military time, is it the same??? or not???


            tnx...

            Comment

            • Killer42
              Recognized Expert Expert
              • Oct 2006
              • 8429

              #7
              Originally posted by Serenityquinn15
              one more question, in time we use military time, is it the same??? or not???
              Yes, VB can handle 12- or 24-hour time formats.

              Comment

              • lotus18
                Contributor
                • Nov 2007
                • 865

                #8
                Hi Serenityquinn15

                You're welcome

                Rey Sean

                Comment

                • Serenityquinn15
                  New Member
                  • Oct 2007
                  • 30

                  #9
                  Originally posted by lotus18
                  Hi Serenityquinn15

                  You're welcome

                  Rey Sean
                  Thanks. It works fine... hehehe....

                  Comment

                  Working...