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

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

could you please supply us with the version of Excel you are using? it's under Help About Excel

Mar 04, 2008 | Excel (SS8SATAS5128400R)

Formula

You can copy any selected cell(s), and then in the sheet you want a link in, select 'Paste Special' from the Edit menu, and then choose 'Paste Link.' I have assumed that you're working in Excel, since you mentioned sheets. The pasted link will update any time you open the second sheet with the links in it.

Oct 13, 2007 | Microsoft Office Standard for PC

Open Questions:

Related Topics:

133 people viewed this question

Level 3 Expert

Level 3 Expert