The Online TimeSheet-Calculator, Calculates Working Hours

Scroll all the way down beneath the Online Calculator, if you want Excel or OpenOffice versions of the TimeSheet-Calculator, or if you want to read the instructions and general information.

Note: The ONLINE TimeSheet-Calculator uses the military time system.  To convert add 12 to all PM time, except for 12 PM.  For example, 1:25 PM, becomes 13:25, and 5:30 P.M. becomes 17:30, but 12:59 P.M. is 12:59.  Do not use AM or PM for the ONLINE version.

 

For a printer friendly version of the Online TimeSheet-Calculator, left click here.

 

  Part-1: To listen to a sound recording of the instructions left on these words.  

 

  Part-2: To listen to a sound recording, with additional information left click here.     

                         
Delete the date in the white box, and then enter your start date. The total Hours worked in this two week period is:
 
The total hours for the first week is
Start Time End Time Start Time End Time Start Time End Time Start Time End Time Start Time End Time
Total hours for the day Total hours for the day Total hours for the day Total hours for the day Total hours for the day
                     
 
The total hours for the second week is
Start Time End Time Start Time End Time Start Time End Time Start Time End Time Start Time End Time
Total hours for the day Total hours for the day Total hours for the day Total hours for the day Total hours for the day
  Designed and Built by David Alderoty June, Copyright 2009, all rights reserved. 2009

 

                           

 

 

Free Downloads for Excel and Openoffice.Org Versions of the Timesheet-Calculator

 

The download links, for the Excel and OpenOffice.org versions of the Timesheet-Calculator, are presented below, and they will be followed by instructions and general Information.

 

To download the TimeSheet-calculator in the Excel format left click on these words. (Requires Microsoft Windows and Excel)

 

To download the TimeSheet-calculator in the OpenOffice.org format, left click on these words.  (Requires Microsoft Windows and the free OpenOffice.org software package)

 

To download both of the above in a single folder, left click on these words.

 

Note: if you do not have Microsoft Excel on your computer, you should use the OpenOffice.org version of the TimeSheet-calculator.  You can download and use the required software package without charge at www.OpenOffice.org

 

 

 

Introduction: a General description of the TimeSheet-Calculator

 

The TimeSheet Calculator is very easy to use. Most people can probably learn how to use it in a few minutes, with a little trial and error learning, and a glance at the following instructions.

 

 

What Does This Calculator Do?

 

The TimeSheet-calculator is software that calculates the time spent working on a job.  This Calculator has a series of boxes to enter the time that work was started, and the time when work was completed for the day.  With this information it calculates the total time an individual was working on a job, per day, per week, and for a two-week period. 

The TimeSheet-Calculator has a text box for each date, to write a message, or describe your work.

The Online TimeSheet Calculator will transmit all the information that was entered or calculated to a designated location, by pressing a submit button.  There is a submit button on the top and bottom of the calculator.  This of course does not apply to the Excel and OpenOffice.org versions, but they can be delivered as e-mail attachments.

 

 

 

The three versions of the TimeSheet-Calculator

 

The three versions of the TimeSheet-Calculator function in very similar ways.  Thus, the instructions apply to the three versions, with a few exceptions.

 

 

How to Enter Text and Numbers into the Calculator

 

You must left click with the mouse on the box (the cell) that you want to enter words or numbers in, to properly position the cruiser.  (This is extremely important.)  Alternatively, you can use the tab key to move from one box to another, by repeatedly pressing it, until the cruiser is in the appropriate box. 

With the Excel and OpenOffice.org versions you can also use the arrow keys to position the cruiser, and for downward movements, you can repeatedly pressed the enter key.

 

After Entering Numbers, How Do You Obtain Calculated Results?

Moving the cruiser outside of the box (cell) that you entered the numbers in will generally produce the calculated results.  This can be done by left clicking with the mouse, (outside of the box that you entered numbers in,).  You can also obtain calculated results by pressing the tab key.  For the Excel and OpenOffice versions, you can also press the enter key.  For the online version you can press a calculation button on the top and bottom of the calculator.

       Calculated results for the three versions of the TimeSheet- Calculators are displayed in red.

 

 

Enter Your Name, And Other Optional Information

There is a light colored box on the upper left of the Timesheet-Calculator.  Delete the words in this box, and write your name.  On the upper right there is another light colored box, where you can enter additional information, but this is optional.  However, you might want to enter your e-mail, phone number, home address, and any messages about problems or successful outcomes with your work.  You can put over 1000 words in this box, because it scrolls downward as text is added.

 

 

Entering the Date on the Top of the Calculator

There is a white box on the top of the calculator with a date.  Delete this date, and enter the start date of the current two-week work period. 

This date must start on a Monday, even if there was no work on that date, because of a holiday.  The start date must be entered as: month/day/year.  For example, 6/8/09, or 6/8/2009 is the correct format.  If the date is entered in any other format, the calculator will not function.

After entering the date, left click with the mouse on any part of the calculator (except in the box where you entered the numbers,) and it will automatically calculate the 10 dates of the two-week work period. Saturday and Sunday are excluded, and are not displayed.

 

 

 

Entering the Start Time and End Time of Your Work.

To use the calculator enter the time that you started work and the time you ended work, for each day that you worked.  The time you started work must be entered in the box labeled Start Time, and the time you completed work must be entered in the box labeled End Time.  Leave the dates that you did not work blank.

For the Online Timesheet-Calculator time must be entered in the military format.  To convert add 12 to all PM time, except for 12 PM.  For example, 1:25 PM becomes 13:25, and 5:30 P.M. becomes 17:30, but 12:59 P.M. is 12:59.  The morning time (a time with an AM) is written in the military format the same way as the conventional style, but without the AM.  Keep in mind that if either AM or PM is entered into the  Online  TimeSheet-calculator it will not function. 

The above does not apply to the Excel and OpenOffice.org versions of the Timesheet-Calculator.  For the Excel and OpenOffice.org versions time must be entered in the conventional format, AM for morning and PM for the afternoon and evening hours.

 

 

Writing a Message, or Describing Your Work For Each Date

You can write a message in the yellow boxes on top of each date, describing your work, and related problems and achievements.  This is not required for the functionality of the calculator, but it may be required by your organization.

If you find it difficult to write directly in the text boxes you should write your message in Microsoft Word, or any other software, and then cut and paste the text into the yellow boxes.  Do not worry about putting in too many words, because each text box can hold over 1000 words.  

 

Electronic Submission of Your Text, Numbers and Calculated Results

After entering numbers, and text, and obtaining calculated results, you can send this information to a location designated by your organization.  To do this you do not have to print anything, fax anything or mail anything.  To transmit all the information on the calculator, simply press the submit button, which is located on the top and also on the bottom of the calculator.  This will automatically send a life-size picture of the calculator, with all your information, to the location designated by your organization.

 

 

Printing, and Submitting Your Information

You can print all the information on the calculator, by pressing the print button, located on top and on the bottom of the calculator.  No matter what methods you use to transmit your information you should always print the data on the calculator, in case there is a problem with submission. 

If you do not want to submit your information electronically, you can fax, mail, or deliver in person the printout that you obtain from the calculator.

 

 

If You Are Going To Print, Use The Printer Friendly Version

Always use the printer friendly version of the calculator, if you plan to print the data from the online calculator.  If this is not done, you might get all of the text on this webpage printed.  There is a link on the upper portion of this website, for the printer friendly version.  However, I will provide an additional link here.

 

For a printer friendly version of the Online Timesheet Calculator, left click on these words.

 

 

The Online Timesheet-Calculator Cannot Save Data

 

As soon as you close the Online TimeSheet-calculator, all the information you entered automatically disappears.  That is the text and numbers you entered, and the calculated results, are not retained by the software.  From a practical perspective, this means you must enter all the data in the Online TimeSheet-calculator at the same time , and then press the submit button.  This generally involves entering the working hours for a two-week period, and then pressing the submit button.

It is possible to enter the working hours for a one week time period, or even every day, but this may not be acceptable to your organization. 

 

The Following Can Result In Major Errors, And Miscalculations

 

The Start Time and End Time, Must be on the Same Day

Note; the timesheet Calculator will not calculate a start time and end time that are NOT from the same date.  For example, if you work the night shift and started work at 23:00 (11:00 PM), and completed work at 7:00 (7:00 AM), you cannot use the TimeSheet Calculator, unless you make some adjustments in the way you enter the time.  You would have to use two Start Times, and two End Times, with the above example as follows:

Start Time 23:00 (11:00 PM) and End Time 23:59 (11:59 PM)

Start Time 0:00 (12:00 AM) and End Time 7:01 (7:01 AM.) 

 

If You Do Not Enter Both A Start Time And An End Time All The Calculations On The Timesheet Calculator Will Be Incorrect.

 

You should always double check to make sure that for each and every start time there is an end Time on the same date.  If you notice unusual results, or no results at all after you entered numbers, check all the dates on the calculator to be certain that there are no errors of the type described above. 

For example, with the online version, if you entered a start time of 12:00 and forgot to put the End Time, all total calculations for the two-week period will be incorrectly reduced by12 hours.

 

 

 

General Information on the TimeSheet-Calculator In The Three Formats, Excel, Openoffice.Org, and the Online Version

 

 

Some Advantages of the Excel and Openoffice.Org Versions

The Excel and OpenOffice.org formats of the Timesheet-Calculator are similar to the online version, with some advantages and disadvantages.  The most obvious is you do not have to be connected to the Internet to use the Excel or OpenOffice.org versions.  The most important advantage is you can create a limitless number of permanent records with the Excel and OpenOffice.org versions.  These records can be updated or changed in any way at any time.  None of this can be done with the online version.  

Another advantage with the Excel and OpenOffice.org versions is they use the conventional time format (AM and PM), but the Online version requires the military format for time.

 

Some Disadvantages of the Excel and Openoffice.Org Formats

One of the main disadvantages with the Excel and OpenOffice.org versions is they cannot be submitted electronically by pressing a submit button.  However, they can be transmitted as e-mail attachments.  

Another disadvantage is Excel and OpenOffice.org versions require Microsoft Windows, and Excel, and OpenOffice.org.

The Online version of the TimeSheet-Calculator is in the JavaScript format.  Thus, it does not require any special software, except for a browser that handles JavaScript.  All modern browsers handle this format. 

Generally, software created in the JavaScript format, will operate on many operating systems, including Macintosh and Linux, as long as they have browsers that handle JavaScript.  This applies to the online version of the TimeSheet-Calculator, but it has only been tested with Windows.

 

 

 

 

My name is David Alderoty, and I designed and built this website and the three versions of the TimeSheet-Calculator.

 

I can design user-friendly TimeSheet-Calculators, as well as other types of calculation software to precise specifications, and write the needed instructions.  This includes web based calculation devices, web-based communication forms, websites, and advanced calculators for algebra, trigonometry, correlations, calculus, etc.  I can provide these services based on permanent or temporary employment.  My resume is online at: www.David.100.com/R  A list of my websites is at www.David.100.com

 

If you need my services, you can call me at (212) 581-3740.  You can e-mail me RunDavid@Verizon.net  You can also send your message in a website communication form, by left clicking on the blue words: WEB FORM.

 

My address is 345 W. 50th St., APT 10D New York, NY 10019.  (If you are a great distance from my locality, or are in a foreign country, this is not important.  I can provide these services worldwide, because the software and websites I make can be delivered through the Internet to any locality.)