Working Times and Hours

Documentatie •
In dit artikel

The program always works with hours and minutes, 8:30 means 8 hours and 30 minutes.

  • Values ​​are saved internally as seconds and then displayed in the hour and minute format.
  • When entering timetables, time is rounded to the minute.

Hours in decimal format

The hours can also be entered in digital format (1.5 = 1:30).

  • If you enter a value preceded by the sign ">" or "<" (greater or lesser), the program considers it as a decimal value and converts it to hours and minutes:
    • "<1.50" is converted to 1:30
    • "<1.75" is converted to 1:45 one and three quarters.
  • In the hour counter, enter the number of hours with the decimal separator. For example if you enter 1.75, the program displays the value in hours and minutes (1:45).

Display in digital format

  • The info window also indicates the value of hours in decimals.
  • In the monthly printout certain values ​​are also indicated as decimals (this is because payroll programs often work with decimals).

Speed ​​up insertion

  • Position yourself on the current day.
    • The row of the current day is the one in yellow.
    • Utilities menu → Go to day.
  • Enter the time of start and stop.
    • With the "." computer time is entered.
    • If you enter +5 or -5 (or any other number) the program displays the current time with 5 minutes more or less than the computer time.
  • Copy from the previous week.
    Using the commands menu Actions → Copy, the times of the previous week are resumed.
  • Returns the value of the previous line
    Use the commands menu Data → Copy from above (or the F4 or Cmd 4 button).
  • Vacation or Absence Auto-Completion.
    Go to cell modification (with a space) and the program suggests the hours due, minus the hours already performed.

Hour column blocks

The hours columns of the Journal table are organized in blocks, as explained below.

Hours worked columns

  • Data is entered as hours worked in the Start1 and Start2 columns.
    In the Banana Accounting Plus version, all columns of the hour counter type starting with TimeWork are considered hours worked.
  • As time of entry and exit - data is entered in the columns Start1, Stop1, Start2, Stop2, etc.
    The program calculates the time elapsed

In the Experimental version there is also the total Detail column. If the Row Type contains the value "D" the working hours are added together in the Detail column and not in the Total column.

Total hours worked

The hours indicated in the hours worked columns and those indicated as start and stop times are totaled in the Total hours worked column.

In the Banana Accounting Plus version, there is also the total Detail column. If the Row Type contains the value "D", the working hours are summed in the Detail column and not in the Total column. 

Extra hours

These columns are only present in the Banana Accounting Plus version.
These columns are used to insert hour supplements. In the case, for example, of work on holidays or at night which involves an increase.
The Extra Total is the sum of the extra hours, indicated as hours, and those calculated as a percentage.


There are the Sickness, Holidays, Service or Other columns, where absences are entered.
These hours are added up in the Absence column (TimeAbsenceTotal) and then in the Total column. When calculating the difference between the hours due, absences are considered as paid.
In the Banana Accounting Plus version all the time counter columns starting with TimeAbsence are added to the absence total. The user can add absence columns for other cases.
If you want to take note of absences that do not have to be added to the hours Total, you have to add columns of Hour counter type.


This column serves for accounting adjustments, as in the case where extra hours have been made and these are paid; then to scale them from the total, enter the value with the negative sign in the Adjustments column.

Hours Total

It is the sum of the total hours, considered as hours to be counted and as part of the amount due. It includes the following columns

  • Total hours worked
  • Total hours supplements
  • Total absences
  • Adjustments

Hours due

The Spreadsheet allows you to indicate the hours due. In the case of a contract with a Fixed salary, the hours of the working days are indicated per contract.
In the case of hourly wages, without a fixed number of hours included in the contract, the hours owed part is generally not used.

The employee's daily working time is indicated in the Due column.The value is indicated based on various parameters (see Journal table):

  • The working hours settings are indicated in File properties→ Start.
  • The Festive column.
    The program completes the value due only for the days indicated as Business. 
  • The Due Type column
    By indicating a code, the content of the Due daily column can be set differently.

Difference and Progressive hours

In the Difference column, the program indicates the difference in hours between the Total and the Due.
In the Progressive column, the program indicates the cumulative difference.
If no Due has been indicated, the Progressive will be the sum of the hours worked. This value can be reset by entering the RP (Progressive Restart) code in the Due Type column.


These information columns are used to indicate hours allocated to projects.

Tell us how we can help you better
If the information on this page is not what you're looking for, is not clear enough, or is not up-to-date, let us know.

Share this article: Twitter | Facebook | LinkedIn | Email