We help IT Professionals succeed at work.

Projecting actual and scheduled hours

Medium Priority
380 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
Comment
Watch Question

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

Author

Commented:
Thank you Curt for your response, what do you see as the correct formula to give my desired result
Robert

Author

Commented:
Curt it seems that if I replace now() with today() my formula works
Yes, that's correct. Today() for 3/10/12 = 40978

Curt
The problem with Now() is that it includes Hours, Minutes and Seconds.

Curt

Author

Commented:
Thank you I did not make that connection

Explore More ContentExplore courses, solutions, and other research materials related to this topic.