Question about Toshiba Satellite A100-S8111TD Notebook

# Daily Payroll Time Sheet Calculation

Hello,
I am having trouble with this simple daily Time sheet formula. My start time would be 9:15 am - End 6:15 PM. In this formula, if total time is > than 6, deduct a hour for lunch. Here is my formula =IF((B36-1)") - I am getting a cucular error also.

Posted by on

• Level 2:

An expert who has achieved level 2 by getting 100 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Sergeant:

An expert that has over 500 points.

• Expert

=IF(C3-B3>6,(C3-B3-1)*24,(C3-B3)*24)

Is this what you want ???

B3 has start, C3 has end, formula is in D3

Posted on Aug 17, 2008

• Steve Si Aug 17, 2008

sorry, not quite correct - try this

=IF(((C3-B3)*24)>6,(C3-B3)*24-1,(C3-B3)*24)

• Steve Si Aug 17, 2008

09:15:00
18:15:00

8.00

09:15:00
17:15:00
7.00

09:15:00
16:15:00
6.00

09:15:00
15:15:00
5.00

09:15:00
14:15:00
5.00

09:15:00
13:15:00
4.00

09:15:00
12:15:00
3.00

09:15:00
11:15:00
2.00

09:15:00
10:15:00
1.00

×

Hi,
a 6ya Technician 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 repair professionals here in the US.
Goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### What is the formula to figure 4% daily on 380,000.00 ? Or on any amount ?

so 380,00000 X4/100 X 1 year
it calculated as the amount ( premium ) multiplied by the percentage of 100 multiplied by the period in years or parts of a year
so it can be 100 X 25% or 1/4(25/100) by the period (5 years or daily (1/365 of a year)
This is known as simple interest
compound interest is calculated on remaining premium after payment X the interest rate by the day or week or month
so for example 100 X 4/100 X 1/12 is the first calculation for the month and for the next month the calculation will be premium of 80 ( if a 20 payment was made in the month X 4/100 X 1/12 and so on if payment are made on time
pm the other hand if no payment are made then the premium goes up by the interest rate
so for the next month it is 104 X 4/100 X 1/12 and the month after that 108.16 X 4/100 X 1/12.and so on
banks use compound when calculating home loan repayments and simple interest when paying interest on your deposits
( has to be in the bank for 367 days to get the interest paid )

Nov 30, 2017 | The Computers & Internet

### Please help me to solve the circular reference in 2013 excel file which stop opening the file. Thank you

first start excel and click on formula tab -->Calculation options -->Manual
Now open file, if asks for update formulae, say no.
Now select entire sheet, select formulas tab--> Error Checking -->Trace Error.
It will locate all error containing cells, now rectify the error save it reopen in excel to see if problem is solved.

Apr 12, 2017 | Microsoft Excel for PC

### Average Handling Time for Emails

You only need one formula for this.
Total handling time divided by the total number of emails answered.

May 13, 2013 | Microsoft Excel for PC

### Need help with excel formula

The solution would be to have an input column(e.g. A) that is separate to the hours and overtime columns. Then in the hours column enter =IF(A1<40,A1,40) and in the overtime column =IF(A1<41,0,A1-40)

Oct 28, 2009 | Microsoft Excel for PC

### Steps to figure out formulas in excel

Hello this is Baris,
If you forget about the numbers and start naming your cells you can figure out your own formulas... Example :)

You buy apples, and you pay \$2 per piece

in this case you have 2 numbers to find out how much you will pay.

price per apple
quantity

you have 3 apples you pay 6 dollars very simple right. 2 times 3.

Same thing in excel but this time you will just say price times quantity and excel will do the calculation for you.

Type in A1 Price
Type in B1 Quantity
Type in C1 Cost

Now, Column C is your calculation area.
Type in A2 2 (price for apples)
Type in B2 3 (quantity of apples)
Type in C2 =A2*C2 (price times quantity)

Now on, you don't have to calculate anything. You can change you price and quantity, cost will change by itself. Because the value in that cell is now related to other values in A2 and B2. I hope this gives you a starting point.

Sep 30, 2009 | Microsoft Excel for PC

### Bank process in daily interest calculation

I want how i can calculate daily profit /loss calculation on investment

Sep 07, 2009 | Microsoft Step by Step Visual Basic 6.0...

### Need a formulae for 'Interest calculation' for 'Over-draft loan'

Try this formula=((A1)*(1+A2))-A3 Where: A1 is the original Balance A2 is the interest rate A3 is the money paid for the preceding month

Apr 02, 2009 | Microsoft Excel for PC

### Compounding interest calculation

The formula in C3 is =C2+((C2*(A3/100))/365). This is replicated down the spreadsheet.
Obviously you would have to put in the daily interest rate.

Hope this helps

Jul 22, 2008 | Microsoft Excel for PC

### Average handle time

I have created a spreadsheet for you to a) use and b) to learn from.

It is an Automated spreadsheet (as they should be) which calculates the number of minutes in a working week or month and calculates the average time per email giving Daily, Weekly and Monthly Outputs. It takes into account Public Holidays (or for time off). You can use the Output to create Graphs etc to visually display the Output.

It also allows you to calculate a Part Month average.

I have displayed it as it was CONSTRUCTED and as it would be USED.

The As Used worksheet is Protected and the only Inputs that can be done are in the Green Boxes (also the Saturday and Sunday boxes but you will need to Unhide the Validation List to include these and then to add 2 more columns titled Is Saturday? and Is Sunday? with the appropriate If Statement.

To unprotect the sheet go to Tools - Protection - Unprotect. There is no password so leave this blank.

All the workings are still there, the columns are just Hidden. To Unhide them, highlight the columns to the left and right of the hidden columns, click on Format - Columns - Unhide. To hide them again, highlight the columns that you want hidden, click on Format - Columns - Hide.

The LOGIC used (as in Functions) may seem complex but if you read the Descriptions in the first row you should be able to work out what and why it was done that way. Click on a cell to see what Function was used where.

You said that your spreadsheet was becoming a real mess, well I have created a monster for you (but not a mess).

I have uploaded the file to here:

http://users.tpg.com.au/lesliecl/

Hope this gives you the push to really start using Excel.

Apr 04, 2008 | Microsoft Excel for PC

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

## Open Questions:

#### Related Topics:

137 people viewed this question

Level 3 Expert

Level 3 Expert