Discussion Locked

Excel spread sheet

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I use a spread sheet to organize our orders that need to be shipped out. I want to use a cell to indicate what the actual time was when the order was issued. I know about the now() time, but that seems to change everytime you make an entry. This does hot help me. I need something that keeps a seperate time for each entry. Does this exist?

2 replies

by dklippert

Ctrl+; puts in the date, Ctrl+: puts in the time.
If you want it done with a formul, try this:
=IF(A3="","No Entry",NOW())

This discussion is closed to new replies.