Is it possible have Date and Time remain after file chasnged or saved

[pedro-egoli]

Interested to know if it is possible to use the Now Funtion in two columns , one for Date the other for time, and leave them unaltered when moving to cells before either saving and/or say reopening the next day.

This spreadsheet will show what happens now when I drag down from previous cells

Book1
	A	B	C	D	E	F	G
1	Date	time
2	24/03/2009	15:25	thisshowedas24/3/200915:20whenIfirstdidit
3	24/03/2009	15:25	ItchangedtothisfigurewhenIdraggedformuladown
Sheet1

Thanks again

Pedro

 

[Makrini]

now will operate every time your workbook calculates. You can turn off calculation but that kind of defeats the purpose.

If you are looking for a time stamp - A Macro is a better option. You can then link it to a single cell change event - or even a key.

 

[pedro-egoli]

Thanks Makrini, I thought that might be the answer , am just trying to solve a situation where the date and time of an event are recorded forever, by an easy drag down method.

No good with writing macros .
Great weather down here suppose the same in Brisbane

Pedro

 

[Makrini]

Not sure what you mean? But sounds like using "=now()" then copy paste special values and drag THAT down?

And yeah great weather here too - but I don't have a beach to enjoy it on!

Got to work on getting work from home access - and laptop it in from sunny places sipping ****tails...

 

[pedro-egoli]

Makrini,
In spreadsheet I just wanted to be able to highlight say cells A3 and B3 and use the little black box on right hand bottom of B3 to drag formula down.

Sounds like you have you are heading in the right direction so far as workplace is concerned.

Pedro

 

[Makrini]

You can use "=Now()" and drag it down...

then copy paste special values over the top of the formula

 

[Ivan F Moala]

There are other ways to do this BUT one way is ....
To use data Validation to keep your Dates / Time the same.
Just link the validation to a cell with the formula =Now()
and format your columns accordingly eg Date & Time format.
You then need to select the Date or time via the dropdown selector.

 

[pedro-egoli]

Thanks again Makrini, will try that later.

Thanks Ivan, your solution looks interesting except I am finding a problem with Validating Time

I selected Time /equal to/=Now() and custom formatted as " h:mm" .
When I dragged down it just dragged the previous time.
When I saved file it left Date the same , which it should today but I don't know how it will go tomorrow.
The Time remained the same as above.

Where am I going wrong?

Thanks
Pedro

 

[pedro-egoli]

Anybody able to help with this one please.

Pedro