WHO DO I CREATE A STATICT TIME FORMULA IN EXCEL?

[Carlos]

I want to creat a formula to insert a statict time in a cell depending the
value from other cell.

[Mallycat]

you will have to provide more info than this. What is the other data? What are the conditions that control what time you want.

[Carlos]

Ok!!!

I am doing a inventory and I want to record the time and date when the
record is entered.

Example:

I insert a record in cell A2, and I want to get the date in cell B2 and the
time in cell C2.

Carlos ^_^


"Mallycat" wrote:

>
> you will have to provide more info than this. What is the other data?
> What are the conditions that control what time you want.
>
>
> --
> Mallycat
> ------------------------------------------------------------------------
> Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
> View this thread: http://www.excelforum.com/showthread...hreadid=553775
>
>