webnovel

How to calculate the working hours

2026-07-17 13:03
2026-07-17 15:10

There were many ways to calculate working hours. The following were some common situations: ** 1. Subtract the basic working hours from the working hours (no special circumstances)** 1. ** Calculating using an Excel sheet (Calculating the working hours of multiple employees)** - He opened the Excel sheet that needed to be calculated. Enter [=B2 - A2](where B2 is the off-duty time cell and A2 is the on-duty time cell) in the [Total Time] cell and deduct the on-duty time from the off-duty time. Then, he clicked the drop-down button to complete the fill. This way, he could quickly calculate the working hours of others. Finally, he could click the right mouse button, select [Set Cell format], open the settings window, select [Time], and click the display type that he wanted to set (such as [13:30]) to directly see the total working hours. 2. ** Normal time calculation (for a single working time)** - If the working time is "8:30" and the off-duty time is "18:00", the off-duty time is directly deducted from the working time, which is "18:00 - 8:30 = 9 hours and 30 minutes". However, if there was a lunch break, dinner break, etc., the rest time needed to be deducted. For example, if the lunch break is 12:00 - 13:30, and the dinner time is 18:30 - 19:00, the actual working hours will be calculated differently according to the different intervals between the working hours and the working hours. - Assuming that the working hours are "8:30 - 18:00", the lunch break is "12:00 - 13:30", and the dinner time is "18:30 - 19:00", the specific calculations are as follows: - If the start time (working hours) is <8:30 and the end time (working hours) is < = 12:00 , the actual working hours are the end number-(8:30 ). - If the start time is <8:30, the end time is <12:00, and the end time is <13:30, the actual working time is <12:00 - 8:30. - If the start time is <8:30, the end time is <13:30, and the end time is <18:00, the actual working time is the end number-<8:30 - 1.5 <8:30 <18:00 <18:30 <13:30>, the actual working time is the end number-<8:30 - 1.5 <18:30>(here, the hour is the lunch break). - If the start time is <8:30>, the end time is <18:00>, and the actual working time is <18:00 - 8:30 - 1.5>. - If the start time is <8:30 and the end time is <19:00, the actual working time is the end number-<8:30 - 1.5 - 0.5 (0.5) hours is the dinner break time). - If the start time is <8:30> and the end time is <12:00>, the actual working time is the end number-the start number. - If start time is <8:30>, start time is <12:00>, end time is <12:00>, end time is <13:30>, the actual working time is <12:00 -start number>. - If the start time is <8:30>, the start time is <12:00>, the end time is <13:30>, and the end time is <18:00>, the actual working time is the end number-the start number-<1.5>. - If the start time is <8:30>, the start time is <12:00>, the end time is <18:00>, and the end time is <19:00>, the actual working time is <18:00 -the start number- 1.5>. - If the start time is <8:30>, the start time is <12:00>, and the end time is <19:00>, the actual working time is the end number-the start number-<1.5 - 0.5>. - If the start time is <12:00>, the start time is <13:30>, and the end time is <13:30>, the actual working time is <0>. - If start time is <12:00>, start time is < = 13:30>, end time is < = 13:30>, end time is < = 18:00>, the actual working time is the end number-<<13:30>. - If the start time is <12:00>, the start time is <13:30>, the end time is <18:00>, and the end time is <19:00>, the actual working time is <18:00 - 13:30>. ** 2. Comprehensive calculation of working hours (monthly, seasonal, and annual cycles)** 1. ** Comprehensive calculation of working hours based on the monthly cycle ** - The total number of actual working hours in the comprehensive calculation period should not exceed <<166.64> hours (calculated by multiplying the number of working days per month by the number of working hours per day). 2. ** Comprehensive calculation of working hours based on the seasonal cycle ** - The total number of actual working hours in the comprehensive calculation period should not exceed [500] hours (calculated by multiplying [62.5] working days] by [8] hours per day). 3. ** Annual comprehensive working hours ** - The total number of actual working hours in the comprehensive calculation period should not exceed 2000 hours (calculated by multiplying the annual working days by 8 hours per day, the annual working days are 365 days-104 days (rest days)-11 days (legal holidays)= 250 days). In a work environment, if it involved the accumulation of multiple time periods to calculate the working hours, it would also need to be calculated according to the actual time period and according to the above rules. In addition, if there were special work modes (such as "invisible overtime" situations such as WeChat office), there was currently no specific unified calculation standard, but the company could set up rules and regulations to regulate it. The novel "Ten Years of Death" is equally exciting. Everyone is welcome to click and read it!

Latest Questions

Rain Butterfly's original female version

The singer of the female version of " Rain Butterfly " was Li Yijun. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-07-20 12:19

The two great immortal kings in the Void God Realm of the perfect world

The two Immortal Kings in the perfect Void God Realm were Bird Grandpa and Crystal Wall Grandpa. Bird grandpa was once a dragon race's first emperor level character, known as the second in the world. His true body was the dragon race's ancestor, and his physical body was in the Heavenly Beast Forest next to the Desolate Emperor Pass. The Crystal Wall Uncle's true identity was Daoist Jin, the Emperor Dao Immortal. His physical body was protected by a golden cow, and he was suppressed in the Divine Medicine Mountain Range next to the Heavenly Beast Forest. Both of them were immortal kings from the Immortal Ancient Era. Due to the great battle, they lost their memories, and their primordial spirits came to the Void God Realm to become the masters of the Void God Realm. Later on, with Shi Hao's help, they gradually recovered their memories and even became Shi Hao's battle prowess. They protected the newly built celestial heavens for Shi Hao, and in the end, they died in the great battle. While waiting for the TV series, he could also read the exciting content related to this site!

1 answer
2026-07-20 12:19

The full version of the original song is free to download

Helen sang "Footman" in super quality MP3/FLAC. You could click "Normal download" to enter the timer for 30 seconds, enter the formula to verify, click "Submit", and then click "Start download". You could download it for free. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-07-20 12:18

Female Empress Fantasy

I recommend Life of an Empress, written by Liu Jingtong. This was an ancient romance novel. The Great Zhou Dynasty had two empresses, one who founded the country and the other who destroyed it. After the fallen empress abdicated, the Great Xia Dynasty began. The female protagonist, Yue Jingjing, was an only daughter in modern times. She possessed the body of a dying ancient girl. She didn't have a cheat, and it was extremely difficult for her to be an empress in a world where men were superior to women. She was forced to do so because she was the only bloodline left in the royal family. The love story depicted in the book was unique, and the protagonist was rational and clear-headed. The author's writing style was clean, the plot and language were well grasped, and the disputes in the court were also interesting. The female lead struggled and compromised, while the other characters had distinct personalities. Although it was written in the language of the empress, it was written about the real empress. There were no palace fights and the rhythm was like the female version of the Kangxi Dynasty. The writing style is light and brisk, and there are many characters but not chaotic. All in all, it was a great Great Empress novel. Those who liked strong female novels shouldn't miss it. The novel " Fantasy Queen Breaks the Heavens " is equally exciting. Everyone is welcome to read it!

1 answer
2026-07-20 12:18

The meaning and symbol of August

The meaning of "August is not yet over" was that August was not yet over. There are many meanings to its symbolism: from a time perspective, it means that it is August but the month is not over yet; from a cultural perspective, it can symbolize a continuous state or a perception of time. In the context of " July and Peace " and " August is not yet over,"" August is not yet over " was related to women's self-growth, love, friendship, and other elements. In these stories, it also reflected a state or stage of life. At the same time, in terms of seasons, combined with the time after the beginning of autumn, it meant that autumn was still very long, but it symbolized that people still had a lot of time to enjoy life and pursue their dreams. It was a positive expectation and blessing for life. While waiting for the TV series, he could also read the exciting content related to this site!

1 answer
2026-07-20 12:18

Century voyage or Changjiang No. 3, which is better?

The Century Voyage was a brand new and upgraded "Glory Pro" luxury cruise ship under Century Cruises. It was officially pre-sold on July 11, 2024, and its maiden voyage was on September 13. The ship was 149.99 meters long, 21.2 meters wide, 29.6 meters high, and had a weight of 15,000 tons. It had seven decks and a capacity of 650 passengers. It provided all-inclusive services and butler care. All the tourists on the ship were equipped with cruise butlers, who provided luggage handling and free self-service laundry services throughout the journey. There were also 42 VIP suites with private space and exclusive privileges on the entire floor (exclusive to 12% of the guests on the ship). The price of a standard balcony room ranged from 3,000 to 4,000. Changjiang No. 3 was independently designed and built by China Merchants Group and was tested on November 15,2021. It was 149.99 meters long, 23 meters wide, and 4.7 meters deep. It had a design draft of 3 meters, six floors above the water surface, a maximum passenger capacity of 600 people, and a design speed of 25 kilometers per hour. It was designed and built according to the highest green ship class and intelligent efficiency standards to achieve zero discharge standards. Which of the two was better depended on the individual's needs. If you want to pursue a new ship in 2024 and want to enjoy a more comprehensive one-price all-inclusive service, butler service and other intimate and thoughtful experiences, perhaps the Century Voyage is more suitable; if you pay more attention to the ship's green and intelligent construction standards, zero discharge and other environmental performance, as well as specific ship size, Changjiang No.3 may be a better choice. The novel "Hundred Years of Spaceship" is equally exciting. Everyone is welcome to click and read it!

1 answer
2026-07-20 12:18

What kind of song is it when we gather in the blooming grassland?

There was a song called " Meet in the Blooming Grassland ", which was described as a heavenly sound that was intoxicating. However, no more detailed information about the song, such as the composer, was obtained from the reference materials given. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-07-20 12:18

Who wrote the 1.18-meter-tall male protagonist?

" I Don't Really Want to Show My Love " was a novel written by Nian Shen, a city entertainment star. Entertainment reporters felt that showing off their love wouldn't last long. People who had experienced it felt that there was no true love in the entertainment industry. Fans, on the other hand, felt that their artist's husband was perfect. Fifty years later, the host was shown off by them. " Simulating the Heavens after Becoming Senior Brother Turtle Hermit " was a doujinshi work derived from Brother Nong's light novel, Don't Eat Fish. Chu Feng dealt with the Great Demon King in the Dragon Ball world. He was also present in Naruto, One Piece, and One-Punch Superman. This was a story that simulated the heavens in the other worlds. " Two-Dimensional Fans in the Marvel World," created by Master Qiao Hong. Kylar had transmigrated into an elementary school student and waited ten years before activating his cheat. He lived happily in Marvel with the two-dimensional system. He was super domineering when facing the villains. He was hot-blooded and interesting. The male lead, Kylal Johnson, had a change of dream. The book was based on the release order of Marvel movies. " Reborn Xiangjiang: Hidden Behind the Scenes ", a novel written by Tianshang Hu xy, and a new book," Reborn Xiangjiang: The Rise of a Big Shot ". " Douluo's I Am Not an Evil Soul " was a doujinshi derived from Wang Banxian's light novel. The little monk had transmigrated to Douluo and had a unique martial soul. He grew up in the Body Sect. The story did not change the setting of the original work and made up for the regrets of the original work. The characters were diverse and there were many characters. If you want to read the Doujinshi of the logic Douluo, don't miss it. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-07-20 12:18

Stomach uncomfortable, a little afraid of cold and heat, what medicine to take is good

If the stomach is uncomfortable and afraid of cold and heat, it may be related to deficiency cold of the spleen and stomach or excess cold of the spleen and stomach. For the stomach caused by spleen and stomach deficiency cold, Huangqi Jianzhong Tang can be taken to relieve it. It has the effect of warming the middle and replenishing the deficiency. However, it should be used with caution for those who are allergic to drugs and those with excess cold and heat syndrome. For example, the stomach cold caused by cold evil directly hitting the spleen and stomach can be relieved by taking Liangfu Pill, which has the effect of warming the stomach and regulating qi. However, it should be used with caution for those who are allergic to drugs and those with heat and deficiency syndrome. In addition, Wenwei Jiangni Granules could be used for many stomach problems. Commonly used Chinese patent medicines such as Huangqi Jianzhong oral liquid, Shenpi Shuangbu oral liquid, Fuzi Lizhong pill with Jinkui Shenqi pill, Guifu Dihuang pill with Shenling Baizhu pill could also be used. However, the efficacy of these drugs varies from person to person. If the symptoms persist or worsen, please go to a regular hospital in time to avoid delaying the illness. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-07-20 12:18

summer Catalog

The 'Summer Special' covered many aspects. In terms of games, Fantasy Mobile Games had a summer special sale, and the mounts and clothing styles had been updated. In terms of literary creation, there was a poem written on September 16, 2024, related to the summer special. In terms of tourism, there was a summer special with the theme of escaping the high temperature and embracing nature, introducing cool trips to places such as Songwan Village and the reservoir under the shop. In terms of media reviews, there was a micro-review special that described the scene of summer parting and autumn getting thicker. In terms of entertainment, there was a summer special about Gu Tianle and Lin Gengxin, a summer special about Shunyi Water Works, which showed all kinds of people who worked hard in the hot summer, and a special about comforting summer good things recommended by books.

1 answer
2026-07-20 12:18
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z