id: 15a380409e0c420da9b81e19f768e99e
parent_id: 
item_type: 1
item_id: c5d9a8e7f7b740ee992ba53ab923ea0d
item_updated_time: 1764345612724
title_diff: "[{\"diffs\":[[1,\"Excel自动记录时间，这个公式太妙了，同事都看呆了！\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":27}]"
body_diff: "[{\"diffs\":[[1,\"<html>\\\r\\\n<head>\\\r\\\n  <title>Excel自动记录时间，这个公式太妙了，同事都看呆了！</title>\\\r\\\n  <basefont face=\\\"微软雅黑\\\" size=\\\"2\\\" />\\\r\\\n  <meta http-equiv=\\\"Content-Type\\\" content=\\\"text/html;charset=utf-8\\\" />\\\r\\\n  <meta name=\\\"exporter-version\\\" content=\\\"YXBJ Windows/608924 (zh-CN, DDL); Windows/10.0.0 (Win64); EDAMVersion=V2;\\\"/>\\\r\\\n  <meta name=\\\"content-class\\\" content=\\\"yinxiang.peso.superNote\\\"/>\\\r\\\n  <meta name=\\\"application-data:yinxiang.noteLayout\\\" content=\\\"{\\\"lineSpace\\\":\\\"recommend\\\",\\\"paragraphSpace\\\":\\\"recommend\\\"}\\\"/>\\\r\\\n  <style>\\\r\\\n\\tbody, td {\\\r\\\n\\t  font-family: 微软雅黑;\\\r\\\n\\t  font-size: 12pt;\\\r\\\n\\t}\\\r\\\n  </style>\\\r\\\n</head>\\\r\\\n<body>\\\r\\\n<a name=\\\"34041\\\"></a>\\\r\\\n<h1>Excel自动记录时间，这个公式太妙了，同事都看呆了！</h1>\\\r\\\n\\\r\\\n<div><span style=\\\"\\\"><div style=\\\"max-width: 700px;\\\"><p></p><div style=\\\"--en-blockquote: true; box-sizing: border-box; border-left: 3px solid #b4c0cc; background-position: initial initial; background-repeat: initial initial;\\\"><div>原文链接: <a href=\\\"http://mp.weixin.qq.com/s?__biz=MzU2ODc0MjI2OA==&amp;mid=2247518024&amp;idx=1&amp;sn=03a0ad2c7242a6f69a85857276ee6dad&amp;chksm=fd35b6fe720562bc5f73231a3c9fb06bf848e3f8432f41b8b7d6aaaac995421431189512bcfc&amp;mpshare=1&amp;scene=1&amp;srcid=1210w7J1d7dgsZsUIzwEDhHR&amp;sharer_shareinfo=882fb0ed5d18bf29cb0caee6a3ac58a2&amp;sharer_shareinfo_first=882fb0ed5d18bf29cb0caee6a3ac58a2#rd\\\"><span>http://mp.weixin.qq.com/s?__biz=MzU2ODc0MjI2OA==&amp;mid=2247518...</span></a></div></div><p></p><div style=\\\"-webkit-tap-highlight-color: transparent;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent;\\\">原创</span><span style=\\\"-webkit-tap-highlight-color: transparent;\\\"> 小E教程 </span><span style=\\\"-webkit-tap-highlight-color: transparent;\\\"><a style=\\\"-webkit-tap-highlight-color: transparent;\\\"> Excel从零到一 </a></span><span style=\\\"-webkit-tap-highlight-color: transparent;\\\"><em style=\\\"-webkit-tap-highlight-color: transparent;\\\"></em></span></div><div style=\\\"-webkit-tap-highlight-color: transparent;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent; box-sizing: border-box;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent; box-sizing: border-box;\\\"><p style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; max-width: 100%; letter-spacing: 0.544px; white-space: normal; background-color: rgb(255,255,255); box-sizing: border-box; overflow-wrap: break-word;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; color: rgb(63,63,63); letter-spacing: 1px;\\\">今天跟大家分享下我们如何自动记录数据的录入时间</span></p><p style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; max-width: 100%; letter-spacing: 0.544px; white-space: normal; background-color: rgb(255,255,255); box-sizing: border-box; overflow-wrap: break-word;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; color: rgb(63,63,63); letter-spacing: 1px;\\\">当我们输入数据的时候,旁边的单元格就会自动的记录数据的录入时间,下面就让我们一起来操作下<br style=\\\"-webkit-tap-highlight-color: transparent;\\\"/></span></p></div><div style=\\\"-webkit-tap-highlight-color: transparent; text-align: center; box-sizing: border-box;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent; max-width: 100%; vertical-align: middle; display: inline-block; box-sizing: border-box;\\\"><img src=\\\":/721c935e018e4bab8386598719be48dc\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" style=\\\"--en-marks: %7B%22align%22%3A%22center%22%7D; -webkit-tap-highlight-color: transparent; vertical-align: middle; box-sizing: border-box; border-radius: 12px; width: auto;\\\" width=\\\"auto\\\"/></div></div><div style=\\\"-webkit-tap-highlight-color: transparent;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent; display: flex; width: 100%;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent; display: flex;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent; background: #C9D5FB;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent; border-width: 1px; border-style: solid; border-color: rgb(0,0,0); background-color: rgb(255,255,255); transform: translate(-3px,-3px);\\\"><div style=\\\"-webkit-tap-highlight-color: transparent; width: 100%; height: 12px; background: #4E6ED8; border-bottom: 1px solid #000; display: flex;\\\"></div><div style=\\\"-webkit-tap-highlight-color: transparent;\\\"><p style=\\\"-webkit-tap-highlight-color: transparent; color: #333; font-weight: bold; letter-spacing: 1px;\\\">一、启用迭代</p></div></div></div></div></div></div><div style=\\\"-webkit-tap-highlight-color: transparent; box-sizing: border-box;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent; white-space: normal; box-sizing: border-box;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; letter-spacing: 1px; color: rgb(63,63,63);\\\">首先我们点击【文件<span style=\\\"-webkit-tap-highlight-color: transparent; color: rgb(63,63,63); letter-spacing: 1px;\\\">】</span>然后点击【选项<span style=\\\"-webkit-tap-highlight-color: transparent; color: rgb(63,63,63); letter-spacing: 1px;\\\">】</span>紧接着点击【公式<span style=\\\"-webkit-tap-highlight-color: transparent; color: rgb(63,63,63); letter-spacing: 1px;\\\">】</span>勾选【启用迭代计算】</span></div><div style=\\\"-webkit-tap-highlight-color: transparent; white-space: normal; box-sizing: border-box;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; letter-spacing: 1px; color: rgb(63,63,63);\\\">紧接着我们选择数据录入时间这个区域,然后按快捷键Ctrl+1调出格式窗口,将类型设置为: <strong style=\\\"-webkit-tap-highlight-color: transparent;\\\">yyyy/m/d h:mm:ss</strong></span></div></div><div style=\\\"-webkit-tap-highlight-color: transparent; text-align: center; box-sizing: border-box;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent; max-width: 100%; vertical-align: middle; display: inline-block; box-sizing: border-box;\\\"><img src=\\\":/6648be20dd9b48dd9e99f282ca406d1d\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" style=\\\"--en-marks: %7B%22align%22%3A%22center%22%7D; -webkit-tap-highlight-color: transparent; vertical-align: middle; box-sizing: border-box; border-radius: 6px; width: auto;\\\" width=\\\"auto\\\"/></div></div><div style=\\\"-webkit-tap-highlight-color: transparent;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent; display: flex; width: 100%;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent; display: flex;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent; background: #C9D5FB;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent; border-width: 1px; border-style: solid; border-color: rgb(0,0,0); background-color: rgb(255,255,255); transform: translate(-3px,-3px);\\\"><div style=\\\"-webkit-tap-highlight-color: transparent; width: 100%; height: 12px; background: #4E6ED8; border-bottom: 1px solid #000; display: flex;\\\"></div><div style=\\\"-webkit-tap-highlight-color: transparent;\\\"><p style=\\\"-webkit-tap-highlight-color: transparent; color: #333; font-weight: bold; letter-spacing: 1px;\\\">二、设置公式</p></div></div></div></div></div></div><div style=\\\"-webkit-tap-highlight-color: transparent; box-sizing: border-box;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent; white-space: normal; box-sizing: border-box;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; letter-spacing: 1px; color: rgb(63,63,63);\\\">紧接着我们在数据录入时间的第一个单元格输入公式</span></div><div style=\\\"-webkit-tap-highlight-color: transparent; white-space: normal; box-sizing: border-box;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; letter-spacing: 1px; color: rgb(63,63,63);\\\"><strong style=\\\"-webkit-tap-highlight-color: transparent;\\\">=IF(A3=&quot;&quot;,&quot;&quot;,IF(B3=&quot;&quot;,NOW(),B3))</strong></span></div><div style=\\\"-webkit-tap-highlight-color: transparent; white-space: normal; box-sizing: border-box;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; letter-spacing: 1px; color: rgb(63,63,63);\\\">最后向下填充公式，这样的话当我们输入姓名的时候就会自动的记录数据输入的时间</span></div></div><div style=\\\"-webkit-tap-highlight-color: transparent; text-align: center; box-sizing: border-box;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent; max-width: 100%; vertical-align: middle; display: inline-block; box-sizing: border-box;\\\"><img src=\\\":/b52401fa283e49c9b29c6a15f5d424cc\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" style=\\\"--en-marks: %7B%22align%22%3A%22center%22%7D; -webkit-tap-highlight-color: transparent; vertical-align: middle; box-sizing: border-box; border-radius: 6px; width: auto;\\\" width=\\\"auto\\\"/></div></div><div style=\\\"-webkit-tap-highlight-color: transparent; white-space: normal; box-sizing: border-box;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; letter-spacing: 1px; color: rgb(63,63,63);\\\">跟大家简单的讲解下这个函数，这个函数是一个if函数的嵌套</span></div><div style=\\\"-webkit-tap-highlight-color: transparent; white-space: normal; box-sizing: border-box;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; letter-spacing: 1px; color: rgb(63,63,63);\\\">首先函数会判断a3单元格是不是空值，如果是的话就返回空，如果a3不是空值，就进入下一个if函数IF(B3=&quot;&quot;,NOW(),B3))</span></div><div style=\\\"-webkit-tap-highlight-color: transparent; white-space: normal; box-sizing: border-box;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; letter-spacing: 1px; color: rgb(63,63,63);\\\">在这个函数中会判断B3是不是空，如果是空就返回now函数，now函数的作用是获取当前时间，如果不会空就返回b3单元格本身</span></div><div style=\\\"-webkit-tap-highlight-color: transparent; white-space: normal; box-sizing: border-box;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; letter-spacing: 1px; color: rgb(255,0,0);\\\"><strong style=\\\"-webkit-tap-highlight-color: transparent;\\\">使用这个方法自动记录单元格时间我们需要注意以下两点</strong></span></div><div style=\\\"-webkit-tap-highlight-color: transparent; white-space: normal; box-sizing: border-box;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; letter-spacing: 1px; color: rgb(63,63,63);\\\">1.必须启用迭代计算，迭代计算是指将计算结果代回原变量进行重复计算，直到满足特定数值条件为止，在这里我们可以理解为循环引用</span></div><div style=\\\"-webkit-tap-highlight-color: transparent; white-space: normal; box-sizing: border-box;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; letter-spacing: 1px; color: rgb(63,63,63);\\\">2.使用这个方法只能记录一次时间，当我们回过头去修改数据的时候，时间也不会发生任何变化</span></div><hr style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; border-style: solid; border-right-width: 0; border-bottom-width: 0; border-left-width: 0; border-color: rgba(0,0,0,0.1); transform-origin: 0 0; transform: scale(1,0.5);\\\"/><p style=\\\"-webkit-tap-highlight-color: transparent; outline: 0;\\\"><strong style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; letter-spacing: 0.544px;\\\">想要学Excel，可以点击超链接，了解下我的课程，带你成为Excel高手提高工作效率，仅售49.9 </strong><br style=\\\"-webkit-tap-highlight-color: transparent; outline: 0;\\\"/></p><p style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; letter-spacing: 0.544px;\\\"><a href=\\\"http://mp.weixin.qq.com/s?__biz=MzU2ODc0MjI2OA==&amp;mid=2247516932&amp;idx=1&amp;sn=f4ee4c54de06a97fa500e252fe336c1b&amp;chksm=fc8b9b17cbfc120177d7f83f5cc60ef8fa2bf38cf0b4a3fb5f5c5884148a5950c57d83ef35aa&amp;scene=21#wechat_redirect\\\" style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; color: var(--weui-LINK); cursor: default;\\\" target=\\\"_blank\\\">Excel系列课程（函数、透视表、图表、数据看板）</a></p><p style=\\\"-webkit-tap-highlight-color: transparent;\\\"><br style=\\\"-webkit-tap-highlight-color: transparent;\\\"/></p><div style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; letter-spacing: 0.544px; color: rgb(34,34,34); text-align: center;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; display: flex; width: 661px;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; display: flex;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; width: 41px; height: 32px;\\\"><img src=\\\":/e815afe116d04c8ea4a855c8e9a331e5\\\" type=\\\"image/png\\\" data-filename=\\\"640.png\\\" style=\\\"--en-marks: %7B%22align%22%3A%22center%22%7D; -webkit-tap-highlight-color: transparent; outline: 0; display: block; __visibility: visible; width: auto;\\\" width=\\\"auto\\\"/></div><div style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; display: flex;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent; outline: 0;\\\"><p style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; font-weight: bold; color: rgb(47,47,47);\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; color: rgb(63,63,63); letter-spacing: 1.5px;\\\">END</span></p></div></div></div></div></div><div style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; letter-spacing: 0.544px; color: rgb(34,34,34); text-align: right;\\\"><strong style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; color: rgb(255,0,0); letter-spacing: 1.5px;\\\">坚持创作不易，点个“在看”支持下吧~</strong></div><div style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; letter-spacing: 0.544px; color: rgb(34,34,34); text-align: right;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; color: rgb(63,63,63); letter-spacing: 1.5px;\\\"><strong style=\\\"-webkit-tap-highlight-color: transparent; outline: 0;\\\"><strong style=\\\"-webkit-tap-highlight-color: transparent; outline: 0;\\\">👇</strong><strong style=\\\"-webkit-tap-highlight-color: transparent; outline: 0;\\\">👇</strong></strong></span></div><div style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; letter-spacing: 0.544px; white-space: normal; color: rgb(34,34,34); background-color: rgb(255,255,255); text-align: right;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; color: rgb(63,63,63); letter-spacing: normal;\\\"><strong style=\\\"-webkit-tap-highlight-color: transparent; outline: 0;\\\"><strong style=\\\"-webkit-tap-highlight-color: transparent; outline: 0;\\\"></strong></strong></span></div></div></div></div></div></div></div></span>\\\n</div></body></html>\\u0000\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":13306}]"
metadata_diff: {"new":{"id":"c5d9a8e7f7b740ee992ba53ab923ea0d","parent_id":"f67288c3a0be4374b5d532b5dcc3aabc","latitude":"0.00000000","longitude":"0.00000000","altitude":"0.0000","author":"","source_url":"","is_todo":0,"todo_due":0,"todo_completed":0,"source":"joplin-desktop","source_application":"net.cozic.joplin-desktop","application_data":"","order":1764348818930,"markup_language":2,"is_shared":0,"share_id":"","conflict_original_id":"","master_key_id":"","user_data":"","deleted_time":0},"deleted":[]}
encryption_cipher_text: 
encryption_applied: 0
updated_time: 2025-11-28T21:03:27.876Z
created_time: 2025-11-28T21:03:27.876Z
type_: 13