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

Ad

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

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

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)

If x < or = 40, w=16.5 x,

Else w= 16.5*40 +26.5*(x-40)

Aug 31, 2014 | Office Equipment & Supplies

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

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

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

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

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.

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

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

the formula in HOURS is Time Out - Time In

Mar 20, 2008 | Computers & Internet

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

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.

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

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)

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

Jul 23, 2013 | Microsoft Excel for PC

88 people viewed this question

Usually answered in minutes!

×