Calculation of Excel working time accumulation

It is recommended to go to excelhome to ask, and you can put the example on which forum to try

When it comes to the calculation of man-hours, perhaps also consider that the task is hovered over and continues to accumulate time

hour returns the number of hours for the time value. That is, an integer between 0 (12:00 and 23 (11:00.

Grammar. hour(serial_number)

The serial number represents a time value that contains the hour to be found. Time can be entered in several ways: a quoted text string (e.g. .

6:45 pm"), decimal numbers (e.g., for 6:45 pm), or the result of other formulas or functions (e.g.,

timevalue("6:45 pm")）。

Illustrate. Microsoft Excel for Windows and Excel for Macintosh use different default date systems. The time value is part of the date value and is represented by a decimal number (e.g., 12:

00 pm can be expressed as , as it is half of the day).

Example. If you copy the sample into a blank worksheet, it may be easier to understand the sample.

How it works: Create a blank workbook or worksheet.

Choose an example in the Help topic. Don't pick row or column headers.

Pick an example from the help.

Press Ctrl+C.

In the worksheet, select cell A1 and press Ctrl+V.

To switch between viewing the results and viewing the formulas that return the results, press Ctrl+ (accent marks), or on the Tools menu, point to Formula Review, and then click Formula Review Mode.

A1 Date.

2 3:30:30 am

3 3:30:30 pm

Formula Description (result).

hour(a2) returns the number of hours (3) for the first time value

hour(a3) returns the number of hours (15) for the second time value

hour(a4) returns the number of hours (15) for the third time value

Try.

1. Enter the time data that needs to be calculated in excel**.

2. Then right-click in the blank single-cover Shenyuan grid and select "Format Cells".

3. Select "Custom", set the type to "[h]:mm", and click the OK button.

4. Then enter the calculation formula in the cell: =sum(a1:a3).

5. Click Enter to see that the cumulative duration of the calculation is 39 hours and 40 minutes.

6. Or you can directly enter the formula: =text(sum(A1:A3),"h]:mm"), you can calculate the duration directly without formatting the cell.

1. Open Excel**, enter the time in column A, and select the cell.

2. Right-click and select "Format Cells" in the pop-up options.

3. In the pop-up settings dialog box, select "Custom" to set the time setting to the format of the circle or absolute note below.

4. After clicking OK, click the "Auto Sum" button in the toolbar on the **Xingtuandan page.

5. The time can be accumulated and displayed according to the format of the time.

1. In this example, you need to calculate the number of working days according to the "off-duty time" in column B and the "working time" in column A. The Changsen results are shown in column C.

2. Select cell C2, enter "=" in the cell, and then click the [Insert Function] button.

3. Select "hour" in the pop-up [Insert Function] option box, and then click the [OK] button.

4. The [Function Parameters] dialog box pops up, and in the dialog box, you can enter "b2-a2" into the box, and then click the [OK] button.

5. Return to the worksheet, and the number of working days of the employee is calculated.

Summary. Enter =(c2-b2) in the cell that needs to calculate the duration.

Next, you need to multiply 24 after the formula for the first step.

Finally, press enter to calculate the working hours.

How to calculate cumulative duration in Excel?

1 3 In the cell that needs to be calculated, enter =(c2-b2). 2 3 Next, in the first step, you need to take the formula to calculate the working hours.

Hope it helps.

The night shift and the day shift are mixed together'

You can just count this according to the time.

You're just going straight to the formula.

1. Open Excel**, enter the time in column A, and select the cell.

2. Right-click and select "Set Format Cells" in the pop-up options.

3. In the pop-up settings dialog box, select "Custom" to set the time to the format of the circle note in the figure below.

4. After clicking OK, click the "Auto Sum" button in the toolbar on the ** page.

5. The time can be accumulated and displayed according to the format of the time.

In order to protect the legitimate rights and interests of workers, China's current labor law has clear provisions on the working hours and vacation time of workers. We have sorted out the legal knowledge related to working hours for you, let's take a look at it below, I believe it will be helpful to you.

1. How to calculate the cumulative working hours

According to the Regulations, the number of years of service of an employee shall be cumulative, including the working hours in different units. Article 4 of the Measures for the Implementation of Paid Annual Leave for Employees of Enterprises (hereinafter referred to as the "Measures") stipulates that the period during which an employee works in the same or different employers, as well as the period during which he or she is deemed to have worked in accordance with laws, administrative regulations or regulations, shall be counted as cumulative working hours.

Some employers often determine the number of annual leave days according to the length of time the employee has worked in the employer, ignoring the employee's cumulative working years, and the employee must bear the corresponding burden of proof in the event of a dispute. Therefore, employees are reminded that when joining a new employer, if there is a question of previous years of service, both parties should check in advance.

In addition, the cumulative working hours of employees can also be determined based on file records, social security payment records, labor contracts and other materials.

2. How long does a worker work to be eligible for paid annual leave?

More than one year of continuous work.

Article 2 of the Regulations on Paid Annual Leave for Employees stipulates that employees of government agencies, organizations, enterprises, public institutions, private non-enterprise units, individual industrial and commercial households with employees, etc., who have worked continuously for more than one year, are entitled to paid annual leave. In order to be eligible for paid annual leave, employees must have worked for the same employer for at least one year. In practice, some employees frequently change jobs and change employers after a few months, so such workers cannot enjoy the right to paid annual leave because they cannot meet the prerequisite of "working continuously for one year".

Of course, even if you meet the conditions for accumulating working hours, you may not be entitled to paid annual leave. Article 4 of the Regulations on Paid Annual Leave for Employees stipulates that an employee shall not be entitled to the annual leave of the current year under any of the following circumstances: (1) the employee enjoys winter and summer vacations in accordance with the law, and the number of days of leave exceeds the number of days of annual leave; (2) The employee takes personal leave for more than 20 days and the unit does not deduct wages in accordance with regulations; (3) Employees with several belts who have worked for 1 year but less than 10 years, and have taken sick leave for more than 2 months; (4) Employees who have worked for 10 years but less than 20 years and have taken sick leave for more than 3 months; (5) Employees who have worked for more than 20 years and have taken sick leave for more than 4 months.

3. Is sudden illness during working hours considered a work-related injury?

According to the definition stipulated by the International Labor Organization and China's laws and regulations, a work-related injury refers to an accident injury or occupational disease hazard suffered by an employee due to work. If the sudden illness is caused by one's own reasons, it is not considered a work-related injury.

The above is to give you a detailed introduction to how to calculate the cumulative working hours, from the above, it can be seen that when calculating the cumulative working hours of an employee, the working hours of different units should be included.