Question about Toshiba Satellite A100-S8111TD Notebook

1 Answer

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.
Please help if you can, And if there is another fomula I should be using please inform me.

Thanks in Advance.

Posted by on

1 Answer

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

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

×

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Why am I getting only half page of a copied email. Plus I always get a blank sheet of page at the same time.


Are you talking about a page printed from a printer or something on your screen? I need some more information before I can help you. It does sound like you are describing a printer problem and if it is, does this happen when you try to print anything else?

Sep 17, 2014 | Dell PC Laptops

2 Answers

Setting clock on laptop toshiba need to find out how to change time on laptop pc


Click on the clock time and you can edit the time and date.

The clock time is on the bottom right hand side of the desktop.

Feb 07, 2014 | Toshiba PC Laptops

1 Answer

I have and HP G71 and it is only about 6 months old I have recently restored the entire system to brand new. Recently the thing just started shuting off all by itself for no apparent reason today it


It seems that your system memory is the cause of problem
You can run a diagnostic check on the system memory.
If you have two memory sticks in the system try to run the system with one memory stick installed at a time, This will give us a proper idea of which memory stick is causing the problem.

Sep 27, 2012 | HP PC Laptops

1 Answer

A hard disk failure is predicted daily from 2 months during the time of strt up ask to press f1in my samsung n150


Hello

Go into the BIOS (press F1 at startup) and scroll over to the boot options section and change the boot order so that the hard drive is first.

Sep 07, 2011 | Samsung N150 (36725723009) Netbook

1 Answer

Do you have a formula in Microsoft Excel that a value can convert to a word...(Ex. 15,000 then it will convert to in words fifteen Thousand..)thanks. need immediate reply.


Hi enelrah_mel0,

You can create a function called SpellNumber using the Visual Basic Editor in the Microsoft Excel to spell the number.

  1. Please Open Microsoft Excel. Then press Alt + F11 to open the Visual Basic Editor.
  2. Then, click "Insert" option above the Visual Basic Editor window and select "Module".
  3. Then, in the Book1 Module1 (Code) window, paste the below code there. (pasted in the next post separately for your convenience)
  4. Then, press Alt+Q to close the Visual Basic Editor window.
  5. After that, please type the formula " =SpellNumber( * )" in the Excel Sheet and press the Enter Key.
  6. Then, save the Excel Sheet.
eg: =SpellNumber(A1)

Where A1 is the first cell in the excel sheet.


Good Luck!

Please post back the result and let me know if you require further assistance.

Thanks for using Fixya.

Oct 29, 2010 | IBM ThinkPad T30 2366 Notebook

1 Answer

P105-56014> clock runs slow.> This is a daily problem> when I start up it will be on yesterday's date.> I reset the time and date and the clock runs slow. I set it 3 hours ago and it is 90...


No
the clock is not running slow. Double click your clock.You will see three tabs: Date&time, Time Zone, Internet Time.
click internet time and you will see tick mark on internet. remove it by clicking on it
If grayed out , reset your time and date

Aug 05, 2010 | Toshiba PC Laptops

1 Answer

Not able to scroll on my excel sheet


It's only in Excel you can't scroll? Can you scroll from side to side? If you have Excel 2003, try to press the "window" tab on the top and if the freeze pane is checked, uncheck it. Or if it says unfreeze pane, press that one. Hope this helps :)

Jul 20, 2009 | IBM ThinkPad T42 Notebook

1 Answer

Buisness Compaq nw8440 Dead.


I would go on the HP or Compaq website. There is a live chat there to talk to a service rep. There are a lot of HP and Compaq notebooks with this issue. (My wife just had one.) They are offering a free one time repair for certain models. Good Luck.

Dec 28, 2008 | HP Pavilion dv6000z Notebook

1 Answer

Buisness Compaq nw8440 Dead.


Try repairing the start-up by booting up from the install disc. Then select repair when asked.

Dec 28, 2008 | Acer AS3613WLCI-XPH CM Notebook

1 Answer

Fuse values for PC's


I'm not sure that I understand your question..if you are referring to the AC  power at the receptacle or what. 

 

If you are asking what value fuse should be used for plugging in particluar equipment then you need to know the source VOLTAGE,  AMPS used bt the equipment and do a current calculation. 

 

Google on the "electrical power triangle" or POWER FORMULA and you can see the formulas.

Oct 15, 2007 | Dell INSPIRON 6000 CENTRINO...

Not finding what you are looking for?
Toshiba Satellite A100-S8111TD Notebook Logo

Related Topics:

133 people viewed this question

Ask a Question

Usually answered in minutes!

Top Toshiba PC Laptops Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

joecoolvette
joecoolvette

Level 3 Expert

5660 Answers

john smith

Level 2 Expert

366 Answers

Are you a Toshiba PC Laptop Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...