Question about Microsoft Excel for PC

Wages bill reg

Hi
i require to get the calculation done in my excel eg if a person comes for job at 8.00AM to 8.00Pm the working hours is twelve how to get this in excel

Posted by on

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

Governor:

An expert whose answer got voted for 20 times.

• Expert

Format both cells with the time format "h:mm AM/PM".
Lets say the start time is in cell A2 and the stop time is in cell B2. In cell C2 put the formula =B2-A2 and custom format the cell C2 as: "h:mm"

Posted on Apr 16, 2009

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)
Goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

Related Questions:

IF STATEMENT

Let x be the total number of hours worked. Let w be the total wage.
If x < or = 40, w=16.5 x,
Else w= 16.5*40 +26.5*(x-40)

Aug 31, 2014 | Office Equipment & Supplies

Setting TI MITE MODEL PLTI-O

This timer has a fixed setting for turning on lights or appliances. To set the time, turn the small dial marked '8765' (which represent the hour when the lights will turn ON, so that the time you desire is next to the current time. In other words, if the current time is 6:00pm, and you want to have the lights come on at 8:00pm, set the 8 on the small dial next to the 6:00pm on the timer body, and plug everything in.

May 01, 2012 | Office Equipment & Supplies

HOW DO I CHANGE MY WATCH FROM 24 HOUR MODE TO 12 HOUR MODE?

click on mode or setting option.then you will see the default time.edit it..try to change it using select or any mode available.there you can see 24hr clock and 12 hr clock.select which one you want.if it is in 12 hr then the time will be displaying like eg:7:00am or 7:00pm it means that it is in twelve hours.if it is showing 7:00 or 19:00 it means it is in 24hr clock.

Jan 29, 2011 | Casio W71-1V Wrist Watch

Excel wont calculate when changes are made to an existing file.

Looks like you will have to re-install Excel from original CD again.

May 28, 2009 | Microsoft Excel 2000 Step by Step...

Excel formula

Hello,
The formula should go like this:
=IF(C11>40,(C11-40)*D11,0)
This one will give you the result of (ONLY overtime hours)*(hourly wage), and if there are no overtime hours the result is 0.
Now, if you need to multiply that result with say 1,5 or whatever - insert the number you need like this:
=IF(C11>40,(C11-40)*D11*1.5,0)

Sep 14, 2008 | Computers & Internet

TV timer

You are most likely setting the sleep timer.

Sep 09, 2008 | Televison & Video

Excel calculations

Just enter using this style

TIME IN TIME OUT HOURS 10:00 16:50 6:50 10:22 17:34 7:12 9:00 10:00 1:00
the formula in HOURS is Time Out - Time In

Mar 20, 2008 | Computers & Internet

Sort data and create graphs for each quarter

you could have all the data in the same worksheet, but sort it using filters, eg data....sort.....auto-filter. click on the little arrow at the top of each column, then click on the item listed. this will then show only those rows associated with that item.

Jan 13, 2008 | Microsoft Excel for PC

Excel argument

If I understand correctly, you want to figure the normal wages at 40 hours and less. If there is more then 40 hours, calculate the normal 40 hours, then calculate the hours overtime (time and a half) and add them to get a total.

B5 columns are filled with this:
=IF(A5>\$B\$1,(\$B\$2*\$B\$1)+((A5-\$B\$1)*(\$B\$3)),A5*\$B\$2)

NOTE: The \$ sign doesn't refer to money, it refers to an absolute reference so when copying a formula, the cell references with a \$ sign are fixed and don't adjust according to the relative position to where it's being pasted.

Oct 22, 2007 | Microsoft Excel 2003 (06503995)

Related Topics:

88 people viewed this question

Level 3 Expert

Level 3 Expert