JP2879873B2 - Display processing method of serial number time data - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a display processing method for converting serial number format time data into other time display format data such as time, cumulative time, cumulative minute, etc., which is useful for a tabulation calculation processing system. About.

[0002]

2. Description of the Related Art In data processing involving time calculation, time,
If normal time data consisting of minutes and seconds is used, it is necessary to carry out the algebraic conversion process while always being aware of the 24-ary system and the 60-base system, and the process becomes complicated. Data is used. The time in the serial number format is based on the length of one day, and the time length of one day is 86,
Since there are 400 seconds, the length of a day is measured in the unit of 1 / 86,400 in the 86,400 base. Thus, for example, one minute is 60 / 86,400,
60 × 60 / 86,400 for 1 hour, 24 × 60 for 1 day
× 60 / 86,400 = 1. A2, B2, and C2 shown in FIG. 4A are examples of serial number time data.

In the conventional tabulation calculation processing system, serial number time data is converted into a normal time (hh), a minute (mm), a second (S
To convert to the time data consisting of S), ignore the integer part of the serial number time data in order to make it a non-cumulative cyclic display format,
The fractional part is multiplied by 86400 to convert to data in the form of seconds, then divided by the number of seconds in one hour 60 × 60 = 3600 to obtain a time value (hh) from the integer part of the quotient, and further dividing the remainder by one minute. Is divided by the number of seconds 60 to obtain a minute value (mm), and the last remainder is output as a second value (ss). FIG. 4B shows the serial number time data of FIG. 4A converted to normal time data.

In a conventional system, a time display method used is a 24-hour format or a 60-minute format.
As described above, when the display format is converted, since the integer part of the serial number time data is ignored, when the time exceeds 24:00 or 60 minutes, the non-cumulative cyclic display that returns to 0 hour or 0 minute is performed. . FIG. 4C shows A2 + B2.
An example in which + C2 is expressed in the range of 24 o'clock is shown. However, as shown in FIGS. 4 (d) and 4 (e), the accumulated time display format in which the accumulated time is displayed as it is even after 24 hours, or the time display in minutes in the same manner, even if it exceeds 60 minutes. In some cases, the user may require a display format such as the accumulated minute display format that displays the accumulated minutes as it is.However, in the conventional system, the system does not have the function to support it. Must be defined and the display format must be converted.

For example, in a conventional spreadsheet calculation processing system using a spreadsheet, when it is necessary to display data accompanying time calculation in a cell in a table in a combined form of accumulated time and minute, such a cell position is required. In each case, an operation for setting a calculation formula for converting serial number time data into data in a desired time display format has to be performed.

FIG. 5 is a flow chart showing operations performed by a user when displaying the accumulated time (minutes) in such a conventional system. In a certain cell of the spreadsheet, the user checks A2 in the example of FIG. 4 (c) or (e).
When a time calculation expression such as + B2 + C2 is set for the serial number time data, the operation shown in steps (1) to (7) in the flow of FIG. 5 is then performed.

First, in (1), (2) and (3), it is determined whether the time display is to be the cumulative time display, the cumulative minute display, or the combined display of the cumulative time and minute. In each case, the expression represented by any of (4), (5), and (6), that is, (4) is an expression for converting a serial number to an accumulated time, and (5) is an expression for converting a serial number to an accumulated time Expression,
In (6), an operation for setting an expression for converting the serial number into the accumulated time and minute display is performed. Next, in step (7), a display format conversion instruction operation is performed, and display is performed in the accumulated time (minute) format.

[0008]

In the conventional tabulation calculation processing system, when a calculation is performed on serial number time data, if the calculation result exceeds a reference value range such as 24:00 or 60 minutes, it is circulated non-cumulatively. It was not easy to display the correct accumulated time or minute that was displayed and exceeded the reference value of the calculation result.

SUMMARY OF THE INVENTION It is an object of the present invention to provide a tabulation calculation processing system using serial number data so that a user can realize display in the form of accumulated time (minutes) by a simple operation.

[0010]

SUMMARY OF THE INVENTION The present invention relates to a serial number format.
Time data is displayed cumulatively in units of hours or minutes.
Formula to be converted to time display format and non-sequential format
Total time to convert time string data to serial number format time data
The above formula based on the formula and the selection instruction operation from the user
Means for selecting any one of
Time data in any serial number format
Apply the selected formula to perform the display format conversion process.
And outputting time data of the conversion processing result .

FIG. 1 is a diagram illustrating the principle of the present invention. FIG.
1, 1 is a keyboard, 2 display device, 3 is a tabulation calculation processing unit, and 4 is a time display conversion processing unit.

The table calculation processor 3 calculates table data based on input commands, table data, and calculation formulas while interacting with the user via the keyboard 1 and the screen of the display device 2, and calculates the table data. Perform tabulation processing to output the results in a data table. At this time, if the table data is serial number time data, the tabulation calculation processing unit 3 requests the time display conversion processing unit 4 to perform a process of converting the display format.

The time display conversion processing unit 4 selects a calculation formula for display format conversion in accordance with an operation instruction from a user for each serial number time data to be displayed, executes a calculation, and Is converted to the format intended by the user and output in the table. In the illustrated example, the display format selection operation is performed using the time (h
h) a first selection operation for selecting a combination display format of minutes (mm) and seconds (ss); and a display format of any of a 24-hour display, a 12-hour display, and a cumulative time display This is performed in two stages of the second selection operation for selecting the item, and as a result, the 24-hour (non-cumulative) display format calculation formula,
2-hour (non-cumulative) display formula, 24-hour cumulative display formula, minute (non-cumulative) display formula, seconds (non-cumulative)
A conversion formula such as a display format calculation formula can be selected.
However, these are merely examples, and any other calculation formula, for example, a calculation formula of a cumulative second display format, may be included in the selectable range. These calculation formulas are set in the time display conversion processing unit 4 in advance, and the user does not need to input them each time.

[0014]

According to the configuration of the present invention shown in FIG. 1, when the user wants to convert the serial number time data into the accumulated time display format or another time display format during the tabulation processing, the user simply selects the target time display format. And a complicated operation of inputting a calculation formula or macro for conversion each time serial number time data appears becomes unnecessary. Further, since there is no need to input a calculation formula or macro for conversion, it is possible to effectively use a memory and improve performance.

[0015]

An embodiment of the present invention will be described with reference to FIGS. FIG. 2 is a block diagram of a system according to an embodiment of the present invention. In FIG. 2, reference numeral 5 denotes a keyboard, which inputs time data such as a serial number character string or a non-serial number time character string and selects a time display format. Give command instructions for etc. Reference numeral 6 denotes a keyboard control unit which controls a command given from the keyboard to be replaced with an internal command. Reference numeral 7 denotes a processing device which is operated by software for tabulation calculation processing and time display processing. Reference numeral 8 denotes a processing controller, and a keyboard controller 6
The corresponding processing is controlled according to the given instruction. Reference numeral 9 denotes an arithmetic unit, which has a time calculation function based on time data in a serial number format. Reference numeral 10 denotes a time display conversion processing unit which performs a process of converting serial number time data into a time character string in a designated display format, or converting a time character string into serial number time data. Reference numeral 11 denotes a time character string buffer for temporarily stacking the time character string converted as a result of the time display conversion processing unit 10. Numeral 12 denotes an operation result stack for temporarily stacking serial number time data of the result calculated by the operation unit 9. A display character string buffer 13 stores a time character string to be displayed or serial number time data extracted from the time character string buffer 11 or the operation result stack 12. A display device 14 reads a character string stored in the display character string buffer 13 in accordance with display timing and displays the character string on a screen.

The time display conversion processing unit 10 converts the serial number time data into one of a plurality of display formats designated by one.
There are a plurality of calculation formulas for converting to one time data and a plurality of calculation formulas for inversely converting the time data of a designated one of a plurality of display formats into serial number time data.

The processing control section 8 performs a time calculation in which the command given from the keyboard control section 6 uses only the input serial number time data or the serial number time data stored in the operation result stack 12. In some cases, the arithmetic unit 9 is controlled so as to perform time calculation using those data directly. On the other hand, when the time data used for the time calculation includes a non-sequential time character string input or in the time character string buffer 11, the time character string is transferred to the time display conversion processing unit 10. After being converted to serial number time data, the data is passed to the arithmetic unit 9 and time calculation is performed.

The result of the operation by the operation unit 9 is temporarily stored in the operation result stack 12, or sent to the time display conversion processing unit 10 when a specific time display format is specified by an instruction. After being converted to the time display format, it is stored in the time character string buffer 11.

FIG. 3 is a flowchart of the conversion process of the time display conversion processing unit 10 in the embodiment of the present invention shown in FIG. First, a serial number character string or a non-serial number time character string is given as the conversion processing data a. The time string is a unit of time
, The cumulative display is enabled. Next, it is determined whether a serial number character string or a time character string has been given as a (identified as an input attribute).

When given a is a serial number character string (YE
In S), a is multiplied by the number of seconds in the day 86400 to the whole of the integer part and the decimal part of a to obtain the value of the corresponding number of seconds b. Identify the cumulative time format to be performed or the cumulative minute format to perform cumulative display in minutes. Here, one of the formats is specified by a command from the user. Note in this case, Ru time display format output for simplicity only two kinds of cumulative fraction form a cumulative time format Tei. In the case of the cumulative time format (YES), the value of b is divided by the number of seconds per hour 3600 to obtain the cumulative time value. In the case of the cumulative minute format (NO), the value of b is calculated by dividing the value of b by 1 minute. Divide by the number of seconds 60 to obtain and output the accumulated minute value. If you want to be able to process a time character string that is a combination display format of accumulated time, minute, and second, divide the remainder after calculating the accumulated time by 60 to find the minute, and add it to the second value of the remainder. Just output it.

On the other hand, if the given data a is a time character string (NO), a process of converting the time character string into a serial number character string is performed. First, a in the time character string is separated into a time part, a minute part, and a second part, and the time part is multiplied by 3600, and the minute part is multiplied by 60 to convert each into a second value. Here, the seconds value of each part is represented by c, d, and e. Next, a total value of c + d + e is obtained and further divided by 86400 to generate a serial number character string. In this case, if the given time character string has a cumulative time value exceeding 24 hours, the integer part of the generated serial number character string will have a value of 1 or more.

[0022]

According to the present invention, even if it is necessary to display the accumulated time (minutes) with the time calculation during the tabulation calculation processing, the display can be performed by a simple operation without increasing the burden on the user much. Can be performed, thereby improving the usability of the tabulation calculation processing system and the efficiency of the processing. Also,
Since there is no need to input a calculation formula or macro for conversion, it is possible to effectively use a memory and improve performance.

[Brief description of the drawings]

FIG. 1 is a diagram illustrating the principle of the present invention.

FIG. 2 is a configuration diagram of a system according to an embodiment of the present invention.

FIG. 3 is a flowchart of a conversion process in the embodiment of the present invention.

FIG. 4 is an explanatory diagram of an example of serial number time data.

FIG. 5 is a flowchart of a cumulative time (minute) display operation in the conventional system.

[Explanation of symbols]

 Reference Signs List 1 keyboard 2 display device 3 tabulation calculation processing unit 4 time display conversion processing unit

Claims (1)

(57) [Claims] 1. A tabulation computing system that performs time calculation processing by using time data of the serial number format, the time data of the serial number format, the time format for performing cumulative in units or units of minutes of time The formula to convert and
Non-sequential time string data is converted to sequential time data
Converted into the formula, and means for selecting one of any upper SL total formula based on the selection instruction operation from a user, the time data of any serial number format to be displayed in the table, the A display method for displaying serial number format time data, wherein a conversion process of a display format is executed by applying a calculation formula selected by the means, and time data as a result of the conversion process is output.