<p class=lexical__paragraph dir=ltr><span>偶爾會有遇到以下這種情況,輸入資料後需要紀錄,輸入資料當下的日期與時間。</span></p><div class=lexical__image center><div class=lexical__imageWrapper><img src=https://images.vocus.cc/47117d20-379b-4d72-9ac6-1b9d0d7a04aa.gif data-original-src=https://images.vocus.cc/47117d20-379b-4d72-9ac6-1b9d0d7a04aa.gif data-width=828 data-height=683 alt=image></div><div class=captionTheme__wrapper><p class=captionTheme__paragraph></p></div></div><p class=lexical__paragraph dir=ltr><span>這個功能到底怎麼做出來的呢?來看看影片教學把她學起來吧,觀看前可以先下載練習檔案,一邊看教學一邊跟著做效果會更好唷。</span></p><p class=lexical__paragraph dir=ltr><a href=https://1drv.ms/x/s!Aj_oP6e_YHdpu0j1WS0ovsvQ2bD3?e=UZeX5e rel=noopener><span>檔案下載</span></a></p><div class=embed-block-prerender data-url=https://youtu.be/K3mrTHzzyHo></div><p class=lexical__paragraph dir=ltr><b><strong class=lexical__textBold>函數翻譯:</strong></b></p><ol class=lexical__ol><li value=1 class=lexical__listItem><span> 當C4儲存格為空白時就會顯示空白 </span></li><li value=2 class=lexical__listItem><span>當C4儲存格不是空白時會判斷B4儲存格是否空白 </span></li><li value=3 class=lexical__listItem><span>當B4儲存格為空白時,顯示NOW函數(函數在B4,又參照到B4陷入循環參照) </span></li><li value=4 class=lexical__listItem><span>當B4儲存格不是空格時(B4空格所以NOW函數顯示時間),就會顯示B4自己(也就是NOW的結果)</span></li></ol><blockquote class=lexical__quote><span>覺得分享有幫助到你在工作上提升效率</span><br><span>可以追蹤</span><a href=https://vocus.cc/user/@efficiencyperson target=_blank><span>我的方格子</span></a><span>或請我喝杯咖啡</span><br><span>也可以訂閱</span><a href=https://vocus.cc/newmind/home target=_blank>設計新思維</span></a><br><span>可以看到更多增加效率的好方法唷~</span></blockquote><div class=lexical__image center><div class=lexical__imageWrapper><img src=https://images.vocus.cc/7500ec59-dede-40e3-87ab-e17f6e1fac04.gif data-original-src=https://images.vocus.cc/7500ec59-dede-40e3-87ab-e17f6e1fac04.gif data-width=1124 data-height=773 alt=image></div><div class=captionTheme__wrapper><p class=captionTheme__paragraph></p></div></div><blockquote class=lexical__quote><span>職場上有相關問題,加入我的</span><a href=https://bit.ly/efficiencypersonline target=_blank>社群討論唷~</span></a></blockquote><blockquote class=lexical__quote><a href=https://www.instagram.com/efficiency_person/ target=_blank><span>追蹤我的IG</span></a></blockquote><blockquote class=lexical__quote><a href=https://www.facebook.com/profile.php?id=100087433032294 target=_blank><span>追蹤我的粉絲團</span></a></blockquote><blockquote class=lexical__quote><a href=https://dcard.me/@gary79205 target=_blank><span>追蹤我的Dcard</span></a></blockquote>