Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

Time function

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Time function

    Ok I am having trouble understanding and I will need help on every step please. I need three fields start time and end time and a field that shows how many hours and minutes, this is for employees time sheet, I need to use regular time not military, I need to put in the start and the end and get how many hour and minutes were worked, can anybody help me PLEASE I have tried everything and I am starting over THANK YOU Guy

  • #2
    RE: Time function

    Guy

    Attached ia a zip file with a sample table showing how to enter time as a character, convert it to seconds, calculate the seconds elapsed, and convert that back to character. Unzip the files to an empty directory. Open the database TimeTest. The table time has a couple entry fields to enter time in character, a couple calculated fields that use toseconds() to convert to seconds, and a field to convert the differnce back to time using totime(). This should give you a good idea how to get what you want.

    Jerry

    Comment


    • #3
      RE: Time function

      Thank you very much, everything was going well until I put in a start time of 9:20 am and end time of 11:15PM and the result was 1 hour and 55 min when it should have given me 13 hours and 55 min, any ideas Guy

      Comment


      • #4
        RE: Time function

        I would suggest Military time.

        Ken

        Comment


        • #5
          RE: Time function

          Thank You for trying you have been alot of help Guy

          Comment


          • #6
            RE: Time function

            Guy

            Small error in the calculated fields

            TOSECONDS(START+" "+S_AM_PM)

            Should be

            TOSECONDS(START+S_AM_PM)

            Change the other calculation in the same way. Incidentally, if a user puts in a time of "10: " it will evaluate incorrectly. It could probably use a validation rule to verify that the entry is a good time. I will take a look later and see what will eork.

            Jerry

            Comment


            • #7
              RE: Time function

              Guy,

              In addition to the previous responses, also look at my
              Time_Difference contribution in the code archive:
              Melvin Davidson 01-16-2002 11:54 AM

              regards,
              Melvin Davidson

              Comment


              • #8
                RE: Time function

                Hey Jerry that did the trick, you have been a great help to me thank you for taking the time, now I am calling on you again I noticed that when a employee works for more than 13 hours and 59 minutes than the program does not work for example I put in 09:20 am to 02:30 am it will give me a negetive number such as -8:10, again Jerry Thanks for everything, I am learning how to do some of this stuff, Guy

                Comment


                • #9
                  RE: Time function

                  Guy

                  You certainly have some dedicated employees to deal with. Actually a more common situation would be a night shift person starting in one day and ending in the next. A normal way to handle this would be to also keep track of the starting and ending date. If they are the same, then the formulas in the sample work. If they aren't, then you would have to find the number of seconds in the first day (86400 seconds in a full day)

                  (86400-START_SEC)

                  Add the seconds in the last day

                  +END_SEC

                  and add any full days in between, 86400 seconds per day. If no one will work more than 24 hours continuously, then you can skip keeping track of the date, since the ending time in the next day will always be less than the start. Therefore, this will work for the elapsed time calc.

                  IF(END_SEC-START_SEC>=0,END_SEC-START_SEC,(86400-START_SEC)+END_SEC)

                  Same day start stop = END_SEC-START_SEC>=0
                  result = END_SEC-START_SEC

                  Otherwise start one day stop next
                  result = (86400-START_SEC)+END_SEC

                  Jerry

                  Comment


                  • #10
                    Re: Time function

                    Hi Jerry.

                    I am also having the same issue with time difference but I didn't see your attachment can you repost. I would really appreciate it.

                    Comment

                    Working...
                    X