Creating a timestamp that is static in a Now formula.

[RAMoore2252]

fI am working with a spread sheet to track break times in spreadsheet. When a specific condition is met in a now () statement I want the result to become a static time stamp in another cell inticating the time an individual went on break. What would the formula be to make the time unchangable. I can share the sheet if needed just let me know where to share it. Thank You.

 

[sandy666]

try
=IF(A2="","",IF(B2="",NOW(),B2))
A2 - enter text manually
B2 - timestamp
Iterative calculation must be enabled

 

[RAMoore2252]

try
=IF(A2="","",IF(B2="",NOW(),B2))
A2 - enter text manually
B2 - timestamp
Iterative calculation must be enabled

Hi,
I have three cells that use this formula on the same row. time for break1, time for lunch and time for break 2. The formula works fine for the first break but when the other two breaks are entered it changes the time to be the same in the previous breaks. How do I fix it so that the time does not change. I can send you an actual copy of my work sheet if needed.

 

[sandy666]

try

Book1 (version 3).xlsb
	A	B	C	D	E	F
2	break1	03:29:51	break2	03:36:35	break3	03:37:30
Sheet4

B2: =IF(A2="","",IF(B2="",NOW(),B2))
D2: =IF(C2="","",IF(D2="",NOW(),D2))
F2: =IF(E2="","",IF(F2="",NOW(),F2))
to use new , eg. break4 you need to delete first text then hit Enter and type new text in the same cell

Book1 (version 3).xlsb
	A	B	C	D	E	F
2	break4	03:42:42	break5	03:43:07	break6	03:43:16
Sheet4

 

[sandy666]

hope it will explain better

 

[RAMoore2252]

hope it will explain better

Here is what I am trying to do. When I use the drop down in the Bold Brk 1 I want the time to show as a static value in the Second column as the time. The same is for Lunch indicating a time they went on break in the left column Lunch. and so on for Break 2. The problem is that as the people take their breaks the same time is updated in each of the preceding cells. I have indicated the columns that are used in the formula.

Break 1

B1 Return

Lunch

L Return

Break 2

B2 Return

End

NAME

STATUS

Brk 1

Lunch

Brk 2

brk1

brk1

lunch

lunch

brk2

brk2

16:00

YONKER, LUKE

blank

brk1

lunch

brk2

20:59:

21:14:

17:00

CLARK, ALEX

blank

blank

blank

20:59:

21:14:

17:00

DILL, SCOTT

blank

blank

blank

column g

column h

column I

column j

column k

column l

column p

column q

column r

 

[sandy666]

it doesn't work this way
you need to delete value to see timestamp cell blank then you can enter new value (manually or from DV List)
this is a simple formula using iterative calculation

maybe try any vba, but you will need for someone else who do that for you

 

[RAMoore2252]

it doesn't work this way
you need to delete value to see timestamp cell blank then you can enter new value (manually or from DV List)
this is a simple formula using iterative calculation

maybe try any vba, but you will need for someone else who do that for you

Thank you for trying. Seems like excel would simplify the process, since so many people seem to have the same idea as to what I am needing.

 

[sandy666]

You are welcome