人気ブログランキング | 話題のタグを見る

Tech Support: calculating time to hours then deduction hours????

calculating time to hours then deduction hours????

Im going to try to explain this the best way I can.
I want to put the time in the start column.
the 7 below is 7am.
Then the time when he is done...6:30pm.
Deduct .5 hr for lunch in the lunch column.
have it Total in the total cell at the end of the row.
As i input more days i need it to total in the "reg" cell up to 40 hr and then in the "ot1" cell total up anything over 40 hrs, if any.
As you can see i have it split up into 2 weeks, thats why there are 2 "reg" cells and an ot1 and an ot2.
dont worry about the Total row at the bottom, ill be removing that i think.
any ideas?

Solutions to the Problem calculating time to hours then deduction hours????

Download SmartPCFixer for Free Now

Hi Evergreen,
With the individual Day's total in column H, the week's totals in column I would be,
=MIN(40,SUMIF($B$2:B2,B2,$H$2:H2))
...
anf the OT totals in column J would be,
=MAX(0,SUMIF($B$2:B2,B2,$H$2:H2)-40)
...
using a combination of absolute and relative cell addressing so that the week's total and OT total grow as they are Filled Down.
I've posted the mockup spreadsheet I been proofing my formulas with on my SkyDrive at,
http://cid-161352ce07628e22.office.live.com/view.aspx/Social%20Answers%20Examples/TimeCards.xlsx
If you run into any seemingly insurmountable problems, post your spreadsheet (with sample data only) at SkyDrive or MediaFire and post the link back here.

Have you tried turning it off and then on again?

Check Windows System Requirements

Microsoft Windows Requirements :

  • 1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
  • 1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
  • 16 GB available hard disk space (32-bit) or 20 GB (64-bit)

You need to double-check your computer's hardware configuration against the following Microsoft requirements. If your PC hardware is not up to par, then make sure you update where necessary before continuing.

Another Safe way to Fix the Problem: calculating time to hours then deduction hours????:

How to Fix calculating time to hours then deduction hours???? with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system.  Open it, and it will perform a scan for your system. The junk files will be shown in the scan result.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been removed.


Related: How to Update ASUS Xonar D2X driver for Windows XP 32/64-bit,Update ATI VGA Driver version 6.13.10.5779,How to Download Chicony Camera Driver version 61.005.029.1900,Download OKI C9800(PCL),How to Update TI Card Reader Driver version 2.0.0.10,Method to Download Toshiba Portege R835-P83 eco Utility v.1.3.21.0 driver,Method to Download Toshiba Satellite A660-BT2N23 Face Recognition v.3.1.3 driver,Download Toshiba Satellite L355-S7907 Face Recognition v.2.0.17.32 driver,[Solved] Download Toshiba Satellite L740-BT4N11 PC Health Monitor Utility v.1.7.9.64 driver,How to Download Toshiba Satellite P305D-S8828 WPS Library v.1.0.0.7 driver,Best Way to Download NVidia GeForce 6100 VGA Driver v.304.51 Certified,How Can You Update & Download NVidia GeForce 9300/nForce 730i VGA Driver v.310.19 Certified,Method to Download NVidia GeForce GT 330M Driver v.340.65,How Can I Update & Download NVidia GeForce GTX 590 Driver v.280.26 WHQL,Method to Download NVidia Tesla C2050 Driver v.319.17
Read More: Fast Solution to Problem: can I insert a graph from word into excel,Troubleshoot:Calendar Data Missing/WindowPrograms Compatibility Error,Can I reintall windows 7 ? [Anwsered],[Solved] can i delete windows updates and reinstall,Troubleshoot:Can a backup run while I'm logged off? I'm using Windows 7. Error,BSOD after upgraded to Windows 8.1 (memory problem?),Blurry programs on Windows 8.1,C:\Window|Microsoft.Net\Framework\v4.0.30319\mscoreei.dll could not be loaded,Browsing history is no longer visible,Bulk deleting from email deleted items folder
by FaxFatalError3 | 2016-08-26 15:20