?
Solved

Projecting actual and scheduled hours

Posted on 2012-03-10
6
Medium Priority
?
367 Views
Last Modified: 2012-03-10
Hi Guys,
Please see the attached file. I am trying to project actual hours for a week.

It seems the formula, IF(NOW()>E3,E7,E6)+IF(NOW()>F3,F7,F6)+IF(NOW()>G3,G7,G6)+H6
should work but it doesn't.

Thank you
Robert
schedule-projections.xlsx
0
Comment
Question by:rsen1
  • 3
  • 3
6 Comments
 
LVL 18

Expert Comment

by:Curt Lindstrom
ID: 37705779
Note that Now() for today will always be greater than the date of today.

eg. 3/10/12 has the value = 40978 and at 10 AM Now() = 40978.42

This means that
=IF(NOW()>E3,E6,E5)+IF(NOW()>F3,F6,F5)+IF(NOW()<G3,G6,G5)+H5
will give this result
=E6+F6+G6+H5
and not
=E6+F6+G5+H5
that you expected as soon as 3/10/12 has started

Cheers,
Curt
0
 

Author Comment

by:rsen1
ID: 37705825
Thank you Curt for your response, what do you see as the correct formula to give my desired result
Robert
0
 

Author Comment

by:rsen1
ID: 37705859
Curt it seems that if I replace now() with today() my formula works
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 18

Accepted Solution

by:
Curt Lindstrom earned 2000 total points
ID: 37705874
Yes, that's correct. Today() for 3/10/12 = 40978

Curt
0
 
LVL 18

Expert Comment

by:Curt Lindstrom
ID: 37705876
The problem with Now() is that it includes Hours, Minutes and Seconds.

Curt
0
 

Author Comment

by:rsen1
ID: 37705883
Thank you I did not make that connection
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an article on how to answer questions, earn points and become an expert.
I came across an unsolved Outlook issue and here is my solution.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question