Question

Locked

Recording time in Excel

By Pmac13 ·
I'm trying to automate my production time sheet. I would like to populate a cell with the hour & minute when information is input into an adjacent cell. Example: information is added to cell F5, the time (hour&minute) is recorded automatically in cell F4.

This conversation is currently closed to new comments.

11 total posts (Page 2 of 2)   Prev   01 | 02
Thread display: Collapse - | Expand +

All Answers

Collapse -

.formula is what has been "entered" to a cell

by TobiF In reply to You Are Correct

Whereas .value I treat rather as the current value of whatever formula the cell contains.

(So I regard .value as readonly, even though Excel has it as read/write)

Back to Software Forum
11 total posts (Page 2 of 2)   Prev   01 | 02

Related Discussions

Related Forums