An IF condition based on time

[pedro-egoli]

I currently have a cell with formula

=NOW()

This of course gives me todays date.
However, what I need is that todays date only appear after 5pm.

Background is that I take a solar reading at 5pm each day and this cell is used by a Summary sheet in a Month to Date column.

Not sure how to go about this so any help will be appreciated.

Pedro

 

[pedro-egoli]

Thanks Jeff,
Copy of B1:C1 below

Excel Workbook
	B	C
1	31-May-11	03-06-11
JUN 2011

You are correct in that it does return 3/6/11, however it is in the MAY sheet and I want it to be no later than 31/5/11, otherwise it throws out the number of days in Summary sheet when the DATEDIF formula is used.
B1 is entered manually.

Headings of various columns take up rows 1:3 so the use of A4 as the start of dates.

Sorry for confusion

Pedro