Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 08-08-2013, 09:21 AM
BobBridges's Avatar
BobBridges BobBridges is offline SumIFS statement (not sure if it is right use) Windows 7 64bit SumIFS statement (not sure if it is right use) Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

If I follow this, you're saying that your worksheet calculates hours correctly up to this date, up to TODAY() I mean, but now you want it to calculate how many hours are left. I see two possibilities:

1) If your contract has (say) 2000 hours on it, and your worksheet shows in F23 that so far 823 hours have been expended, then the hours remaining until the end of the contract are simply 2000 - F23 = 1177.

2) If you want to calculate the working hours remaining between today and 2013-09-20, then the number of hours worked so far doesn't come into it at all; it's just a matter of figuring out how many working days there are between today and 09-20 and multiplying by 8-or-whatever. As I recall, Excel has some functions that handle working hours and days in an add-on. Let's see....here it is; NETWORKDAYS "returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays." But this doesn't say anything about having to install an add-on; maybe they've made it standard in the latest versions of Excel. (I only recently migrated from 2003 to 2010.)
Reply With Quote
 

Tags
calculation, ifs, today



Similar Threads
Thread Thread Starter Forum Replies Last Post
SumIFS statement (not sure if it is right use) I need help with =SUMIFS docwhit Excel 2 01-05-2013 12:58 PM
SumIFS statement (not sure if it is right use) SumIFS Questions Kheinrich119 Excel 2 12-12-2012 10:00 AM
SumIFS statement (not sure if it is right use) if statement piper7971 PowerPoint 1 08-19-2010 07:10 AM
SumIFS statement (not sure if it is right use) Help with IF statement! CPelkey Word 1 04-12-2010 09:06 AM
Help needed using the serial number date with sumifs - whole office is stumped FraserKitchell Excel 3 01-06-2010 12:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:38 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft