日誌2013-04-24 10:26
登出倒數計時器 & 春番七絕作者:A_HA(暫停の呼吸)
欄位 | 內容 |
A2 | 輸入入伍日期,請參考上圖格式 |
B2 | 輸入折抵天數,請參考上圖格式 |
C2 | =TODAY() |
D2 | =A2+365-B2-1 |
E2 | =" " & CEILING(( D2-C2)/7,1) & "週" |
F2 | =" " & (D2-C2) & "天" |
G2 | =" " & (D2-C2)*24 + (24-HOUR(NOW())) & "時" |
H2 | = " " & (D2-C2)*1440 + (1440-HOUR(NOW())*60+MINUTE(NOW())) & "分" |
I2 | =" "&(D2-C2)*86400+(86400-(HOUR(NOW())*3600+MINUTE(NOW())*60+SECOND(NOW())))&"秒" |
J2 | = C2-A2 +1 |
K2 | =(((D2-A2+1)*1440)-((D2-C2)*1440+(1440-(HOUR(NOW())*60+MINUTE(NOW())))))/((D2-A2+1)*1440) 記得將儲存格格式改成百分比 |
2013-04-24 10:53A_HA(暫停の呼吸):我缺動漫插香的GIF圖https://truth.bahamut.com.tw/s01/201212/e878247520096470af6353b7120c5c8e.GIF
2013-04-24 10:54A_HA(暫停の呼吸):好看呀!!!http://i.imgur.com/JDq4VXC.gif
2013-04-24 10:54A_HA(暫停の呼吸):http://i.imgur.com/v4PCqyF.gif
2013-04-24 10:55A_HA(暫停の呼吸):2年... 加油!!! 換作是我一定受不了XDDDDDDD
因為真的好不自由,也沒辦法每天回家http://i.imgur.com/V7m62UL.gif
2013-04-24 10:56A_HA(暫停の呼吸):對呀,正在期待卸載日http://i.imgur.com/ZfDzrI1.gif
2013-04-24 10:57A_HA(暫停の呼吸):我目前只能看到這七部了XD 時間不夠呀http://i.imgur.com/OFbecaT.gif
2013-04-24 11:09A_HA(暫停の呼吸):人氣倒是其次,自己喜歡比較重要http://i.imgur.com/LnB3cKT.gif
2013-04-24 11:08A_HA(暫停の呼吸):原來如此XDDD 學生時代很幸福,好好享受呀http://i.imgur.com/gHSNmlO.gif
2013-04-24 11:17A_HA(暫停の呼吸):http://i.imgur.com/MaDCj7y.gif
2013-04-24 11:31A_HA(暫停の呼吸):有呀!!好看!!http://i.imgur.com/JDq4VXC.gif
2013-04-24 11:36A_HA(暫停の呼吸):折磨人... 怎麼會,我看得很開心呀XDDD http://i.imgur.com/GIwcLRb.gif
2013-04-24 11:50A_HA(暫停の呼吸):很期待狂三呀!!!http://i.imgur.com/3coXukg.gif
2013-04-24 11:51A_HA(暫停の呼吸):等待是煎熬的,但得到果實將因此更加甜美http://i.imgur.com/tqE7mB9.gif
2013-04-24 12:25A_HA(暫停の呼吸):能吃就是福呀http://i.imgur.com/hOWwnfD.gif
2013-04-24 15:04A_HA(暫停の呼吸):原來你是十香控XDDD http://i.imgur.com/hOWwnfD.gif
2013-04-24 18:40A_HA(暫停の呼吸):嗯嗯http://i.imgur.com/MaDCj7y.gif
2013-05-03 19:59A_HA(暫停の呼吸):YEAH!!!一起追呀!!!好看!!!http://i.imgur.com/nyK4B3l.gif
2013-05-05 06:01A_HA(暫停の呼吸):同是動漫迷,請享用http://i.imgur.com/BYAZzWa.gif