Question about Microsoft Computers & Internet

# How to find time

If employee worked from 10:am to 5:00pm then how we calculate working hours.

Posted by on

• Level 1:

An expert who has achieved level 1.

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that hasĀ over 10 points.

Mayor:

An expert whose answer gotĀ voted for 2 times.

• Contributor

Cell a = endtime
cell b = starttime
cell c = cell a - cell b
cell d = hour(cell c)

Posted on Nov 18, 2008

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### What are the top four laws of overtime in California?

California government has made the law to put financial pressure on employers to hire additional staff and to protect employees in weak bargaining positions from being overwork. The top four laws of overtime in California are:
1. Provides overtime at half time and a half of employees regular rate pay for work performed in excess of 40 hours a week.
2. Workers who work more than eight hours in a workday must be paid at one and a half times their regular rate of remuneration.
3. Employees are paid double for overtime for work performed in excess of 12 hours in one day.
4. California law provides that when an employee does work seven consecutive days in a row, he or she must be paid overtime for the entire day of work.
For more details about a law or any legal help, you can look on Overtime California.

Mar 23, 2017 | Cars & Trucks

### How much employees are paid for overtime in California?

Overtime is when an employee works more than a specified number of hours in a week. It is the additional pay rate paid to employees who work more than a specified number of hours in a week. In California, according to law overtime must be paid at one and a half times their regular rate of remuneration.This law has made to protect workers in weak bargaining positions from being overwork. If you want to know more about it, you can see Overtime California.

Mar 23, 2017 | Computers & Internet

### After how many hours a week a employee is considered full time ?

By US federal law a full-time employee is one who works on average at least 30 hours per week, or 130 hours per month.

Nov 06, 2015 | Computers & Internet

### How do I find out a percentage of a number

You likely mean this to be the 'Average' number of employees per day rather than percentage. However you need to work out based on hr's per day that each employee can work. Lets assume though that they work full time, 8hrs per day. Then you would work out as follows:
3223.5 /8 /28 /306 = 0.047 employees per day

If they only work 1 hr per day it would be:
3223.5 /28 /306 = 0.376 employees per day

Each employee would need to work:
3223.5 /306 = 10.53hrs per month

Mar 02, 2015 | Office Equipment & Supplies

### HOW MAN HOURS BREAK IN CALIFORNIA AFTER 8 HOUR SHIFT?

Employees must, with two exceptions, receive at least eight hours free from work between shifts, whether they are "split shifts," "on call shifts," "back-to-back" shifts or ordinary daily shifts.
Rest between shifts is not required if:
• the total time worked during both shifts does not exceed 13 hours; or
• the employer and employee agree in writing to reduce or forego the eight-hour rest period.
Example
Monica works in a restaurant. She is on split shifts, working from 11:30 am to 2:30 pm and then from 4:00 pm to 7:00 pm. The total time of her two shifts is 6 hours. Monica does not need to have eight hours off between the shifts because her total hours worked on the shifts do not exceed 13 hours.
Note: The requirement for rest between shifts operates simultaneously with the requirement for daily rest; an employee's schedule must satisfy both requirements. For example, an employee might agree in writing to work two eight-hour shifts in a row without any time free from work between them (the employee's agreement means there is no violation of the rest between shifts rule), but if that results in the employee receiving less than 11 consecutive hours off in a day, the employer will be in violation of the daily rest rule* and therefore it is not permitted.
* Unlike the case with the rest between shifts requirement, an employee cannot agree to waive the daily rest requirement.

Oct 13, 2014 | Cars & Trucks

### Payroll system in DBMS. I don't know what data is to be taken.

Firstly you need to determine/state whether you are using a database application, such as Access, MtSQL or MS SQL and programming them to do create this application, or are you using a programming development tool such as Visual Studio, ASP.NET, PHP or the like, as the solution and guidance will be different for each.
In terms of the data design, you should store the data necessary to identify each employee uniquely and each data point per employee needed to calculate their payroll. You should then store the generic (applys to all employees) such as tax rates, in separate tables and call on it to calculate wages and other paystub data.
For instance, the employee first and last names and tax ID should be a sufficient unique identifier. Create a table for just employees, their names, tax ID, start date, schedule, pay rate, number of deductions, direct bank payment data, etc., and whatever else you decide you need for each employee. You can calculate their wages by multiplying their rate by their schedule and applying the appropriate tax rate and medical/witholding deductions as you go, so calculated data does not need to be stored and consume database space.
You'll likely need a separate table for common data such as tax rates, one for deductions/witholdings, one for holidays, one for vacation accrual rates, one for medical rates, etc. This data if common to employees does not need to be stored per individual, as that would cause redundant replication of data. If the employees are on an hourly rate, rather than a set salary/wage, then you'll need a table of worked hours per employee, akin to their timesheet data. If you use a timesheet/timecard, the entering and storing only the totals and keeping the physical timesheet for backup records should suffice.
Once you design and populate your database as suggested above, then it's a relatively-simple task of calculating the computed paystub data and storing the salient resulting datapoints for the record.
Consider a reporting application, such as Crystal Reports, for your printing needs, as its far easier to configure Crystal or similar product to format reports, paystubs, checks, etc., than coding these from scratch.
Hope this helps.

Dec 25, 2008 | Computers & Internet

## Open Questions:

#### Related Topics:

57 people viewed this question

Level 3 Expert

Level 3 Expert