Question about Toshiba Satellite A100-S8111TD Notebook

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((B3

Please help if you can, And if there is another fomula I should be using please inform me.

Thanks in Advance.

Ad

=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

Ad

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.

click here to Talk to a Technician (only for users in the US for now) and get all the help you need.

Goodluck!

Posted on Jan 02, 2017

Ad

premium X % X time

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 )

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

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.

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

You only need one formula for this.

Total handling time divided by the total number of emails answered.

Total handling time divided by the total number of emails answered.

May 13, 2013 | Microsoft Excel for PC

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

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.

Lets name your cells

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.

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.

Lets name your cells

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

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

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

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

Please see attached image.

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

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

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.

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

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

137 people viewed this question

Usually answered in minutes!

×