Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Formula for non blank cell
I hope this makes sense... I'm working with a department that uses word to
keep track of when employees are doing their designated duties by system date/time to make sure they aren't fudging the time. I've created a document that has two different tables in it and the first table (7 columns) can be un protected with no worries. However, the second table (2 columns) needs to have cell A1 protected and if a user keys in any text in B1 I need it to add the current date/time to A1 once they hit the enter/tab key. If B1 isnot blank then A1=CREATEDATE \@ "yyyy-MM-dd" \@ "HH:mm:ss" Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy a Table Formula to Another Cell | Tables | |||
cell addresses and formula? | Tables | |||
Formula & Cell #s | Tables | |||
Adding formula in the cell | Tables | |||
I need a formula of amount of hours from two times in two cell? | Tables |