Projecting actual and scheduled hours

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
rsen1Asked:
Who is Participating?
 
Curt LindstromCommented:
Yes, that's correct. Today() for 3/10/12 = 40978

Curt
0
 
Curt LindstromCommented:
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
 
rsen1Author Commented:
Thank you Curt for your response, what do you see as the correct formula to give my desired result
Robert
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
rsen1Author Commented:
Curt it seems that if I replace now() with today() my formula works
0
 
Curt LindstromCommented:
The problem with Now() is that it includes Hours, Minutes and Seconds.

Curt
0
 
rsen1Author Commented:
Thank you I did not make that connection
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.