Question about Microsoft Excel for PC

1 Answer

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

Ad

1 Answer

  • 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
  • 152 Answers

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

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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)
click here to download the app (for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

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

1 Answer

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

1 Answer

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

2 Answers

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...

2 Answers

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)

If you need more help, please ask.

Sep 14, 2008 | Computers & Internet

1 Answer

TV timer


You are most likely setting the sleep timer.

Sep 09, 2008 | Televison & Video

1 Answer

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

1 Answer

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

3 Answers

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.

2bef84b.png

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.

Please rate as FixYa! or ask please clarify. ThankYa!

Oct 22, 2007 | Microsoft Excel 2003 (06503995)

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

88 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2885 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18408 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...