Question: I have a small doubt in excel, there is a data where employee working hours has been mentioned , we have to work on his

I have a small doubt in excel, there is a data where employee working hours has been mentioned , we have to work on his working hours calculation. It is mentioned that there should always be a break of 10 minutes after every period of work of 2.5 hours, but the time under break won't get paid. So i am confused how to find total amount of breaktime using excel. Please enlighten the excel formula so that i can use it for the net paid working hours of employee. Please don't give manual calculation idea I know it's easy manually but I need to automate it using excel formulas. I hope u understand what I want. Thanks!!!

Day	Working hour Start from	Working hour Finish at	Amount of time spent in break (each of 10 minutes after a period of 2.5 hour of working)	Net amount of working hours to be get paid (Out - In - Total Break time)
Monday	10:00 PM	4:00 AM	?	?
Tuesday	6:00 PM	2:00 AM	?	?
Wednesday	9:12 AM	4:48 PM	?	?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Bookkeepers R Us Pty Ltd Extract from POLICIES and PROCEDURES Manual 1 Company Details Bookkeepers R Us Pty Ltd, trading was incorporated on 1st January 2013 as a business that provides bookkeeping...

Shift Determination Full Time (8 Hour) Shifts F01 8:00am to 9:00am 9:00am to 10:00am 10:00am to 11:00am 11:00am to 12:00pm 12:00pm to 1:00pm 1:00pm to 2:00pm 2:00pm to 3:00pm 3:00pm to 4:00pm 4:00pm...

1. Create a package called hrInterface. Define an interface Payable with a calcPayroll method in the package. 2. Create another package called employee. Define three small classes in the package:...

answer the following questions for the below scenario: What is the purpose of the message? Who is your primary audience? Briefly profile them ( 1 5 0 words ) . Who is your secondary audience? What...

for the below scenario, write an outline of a message, a first draft of the message, and a final draft of the message: You work for a company that provides online payroll services for small...

answer the following questions for the below scenario: What is the purpose of the message? Who is your primary audience? Briefly profile them ( 1 5 0 words ) . Who is your secondary audience? What...

Case Study Learners must correctly complete the following project based on the scenario provided: Business overview ABC Real Estate is a small organisation that has a core business of selling garden...

Beanstalk SAS How had it come to this? Erik Mossberger wondered. It was a cold, crisp Saturday morning in early March 2016. Sunlight streamed through the windows of Beanstalk's (BSAS) boardroom....

topic: importance of workalike balance for women as a leader in healthcare. 1. The purpose of the research; 2. Research question/s; 3. Findings and relevant data; 4. Any recommendations and; 5. The...

In 2011, Hoffmann Company had a break-even point of $350,000 based on a selling price of $7 per unit and fixed costs of $105,000. In 2012, the selling price and the variable cost per unit did not...

3. What are the strength and direction of the electric field at the position indicated by the dot in Figure 1 and 27 Specify the direction as an angle above or below horizontal. 3.0 nc 3.0 nC 5.0 cm...

Which of the following itemized deductions would be adjustments to regular taxable income in arriving at alternative minimum taxable income ( AMTI ) ? Casualty losses State income taxes paid Standard...

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

Global. Technology. Teamwork. McBride Industries, an American company, has recently opened a branch office in the Czech Republic. Vladimra Pokorny, a Marketing Assistant for the Czech office, has...

Describe three technology trends and how they affect business communication. (Objective 1)

Teamwork. Global. Work with a partner to review the letter to Mr.Wu in Figure 2.3 on page 39 in this chapter. Explain two communication challenges faced by Mr. Doninger in writing the letter. Also,...