bill351
Board Regular
- Joined
- Jan 19, 2009
- Messages
- 83
Hi Guys n Girls I have a data collection sheet on phone calls made to different staff and in that I have column C as current date and column D as time when the call was made and this is automated from a name entered into column A. My current formula is =IF(A1="","",IF($A$1="",NOW(),$A$1)) | |||||||||
which does what it is suppose to do however as I progress down my sheet and the time rolls from 13:01 to 13:02 it changes all the previous times above to 13:02. How do I keep the times of the calls to when I called like Jim was called at 13:15 in row 5 and then Carol was called at 13:30 in row 6 and Tony at 14:03 in row 7. In its current form when I put Tony in both Jim and Carol's time changes to 14:03? Thanks in advance Bill from Oz | |||||||||
<colgroup><col><col><col span="2"><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>