date is dynamic but time is static.

[lambu]

If I want date to be current and time constant how to do it for ex:
in A1 want display of 8/23/13 8:00 next day when I open excel A1 should display 8/24/13 8:00

so my date is dynamic but time is static.

 

[AhoyNC]

=today()+8/24

 

[shyy]

you mean format?

=MONTH(TODAY())&"/"&DAY(TODAY())&"/"&YEAR(TODAY()) &" 8:00"

 

[lambu]

thanks shyy it worked

 

[lambu]

it did not worked AhoyNC

 

[pgc01]

it did not worked AhoyNC

Hi lambu

AhoyNC's solution is simple and correct.

Maybe you forgot to format the cell as datetime?

 

[shyy]

AhoyNC's solution is much better, you need to format the cell.