[B! excel][æ™‚é–“ç®¡ç†] Glnã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

Gln id:Gln

excelã¨æ™‚é–“ç®¡ç†ã«é–¢ã™ã‚‹Glnã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

æ™‚é–“ã®è¦‹ç©ã‚‚ã‚ŠãŒã†ã¾ãã§ããªãã¦å›°ã‚‹ã€ç†è«–ç·¨ã€‘
ä»Šå›žã®èª²é¡Œï¼šä½œæ¥è¨˜éŒ²ã‚’ã¤ã‘ã‚‹ çŠ¶æ³èª¬æ˜Žï¼šã€Œæ˜Žæ—¥ã¯çµ‚æ—¥ä¼šè°ã®é€£ç¶šã§ã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ«ãŒè©°ã¾ã£ã¦ã„ã‚‹ã€ã‚ã‚‹ã„ã¯ã€Œåˆå¾Œã¯ä¼ç”»æ›¸ä½œã‚Šã§ç¼¶è©°ã‚ã ã€ã¨ã„ã£ãŸè¦‹é€šã—ãŒç«‹ã¤å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚ˆã†ãªæ™‚ã€Œæ˜Žæ—¥ã¯ä¼šè°ã ã‘ã§ä¸€æ—¥ãŒçµ‚ã‚ã£ã¦ã—ã¾ã†ã®ã§ä»•äº‹ãŒé€²ã‚ã‚‰ã‚Œãªã„ã€ã€ŒåŠæ—¥ã‚‚ã‚ã‚Œã°ä¼ç”»æ›¸ã¯å®Œæˆã™ã‚‹ã ã‚ã†ã€ã¨ã„ã†äºˆæ¸¬ãŒåŒæ™‚ã«ç«‹ã¡ã¾ã™ã€‚ ä¼šè°ã§è©°ã¾ã£ã¦ã„ã‚‹ã¨ã„ã£ã¦ã‚‚ã€ä¼šè°ã¨ä¼šè°ã®é–“ã«ã¯ã¡ã‚‡ã£ã¨ã—ãŸç©ºãæ™‚é–“ãŒã§ããŸã‚Šã€ä¼ç”»æ›¸ä½œã‚Šã‚‚åŠæ—¥ã§ã¯åˆ°åº•çµ‚ã‚ã‚‰ãšã«ãã®æ—¥ã¯çµ‚é›»ã¾ã§ã‹ã‹ã‚Šãã‚Šã«ãªã£ãŸã‚Šã€ã¨ã„ã£ãŸæƒ³å®šå¤–ã®äº‹æ…‹ã«è¦‹èˆžã‚ã‚Œã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ä½•ã¨ãªãè¦‹ãˆã¦ã„ãŸã¯ãšã®è¦‹é€šã—ãŒã€ãƒ•ã‚¿ã‚’é–‹ã‘ã¦ã¿ãŸã‚‰ã¾ã£ãŸãç”˜ã„ã‚‚ã®ã§ã‚ã‚Šã€æ€ã‚ã¬è‹¦åŠ´ã‚’ã•ã›ã‚‰ã‚Œã‚‹ã‚ã‘ã§ã™ã€‚ä¸€åº¦ãªã‚‰ã¾ã ã—ã‚‚ã€ç¹°ã‚Šè¿”ã—ã¦ã—ã¾ã†ã®ã§ã‚ã‚Œã°å•é¡Œã§ã™ã€‚ ã“ã†ãªã‚‰ãªã„ãŸã‚ã«ã€è¨€ã„æ›ãˆã‚Œã°ç¾å®Ÿçš„ã§ç²¾åº¦ã®é«˜ã„è¦‹é€šã—ã‚’ç«‹ã¦ã‚‹ã«ã¯ã€ã©ã†ã—ãŸã‚‰ã„ã„ã§ã—ã‚‡ã†ã‹ã€‚ ã‚³ãƒ„ï¼šæ±ºã‚ã‚‰ã‚ŒãŸãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆ
Gln 2009/04/04
=IF(çµ‚äº†="","",(é–‹å§‹-çµ‚äº†)/TIMEVALUE("1:00"))

excel

æ™‚é–“ç®¡ç†

ã‚¿ã‚¹ã‚¯ç®¡ç†
ãƒªãƒ³ã‚¯
ToDoãƒªã‚¹ãƒˆã§ã€Œæœ¬æ—¥ã®å¸°å®…æ™‚é–“ã€ã‚’æŠŠæ¡ã™ã‚‹ã®ã
ToDoãƒªã‚¹ãƒˆã¯ç¾åœ¨æŠ±ãˆã¦ã„ã‚‹ã‚¿ã‚¹ã‚¯ã‚’æŠŠæ¡ã™ã‚‹ã«ã¯ä¾¿åˆ©ã§ã™ãŒã€ã€Œä¸¦ã‚“ã§ã„ã‚‹ã‚¿ã‚¹ã‚¯ãŒã„ã¤ã¾ã§ã«çµ‚ã‚ã‚‹ã®ã‹ã€ã¯æ„å¤–ã¨è¦‹ãˆã«ãã„ã‚‚ã®ã§ã™ã€‚ä»Šå›žã¯ã€ã‚¿ã‚¹ã‚¯ã”ã¨ã®æ™‚é–“é…åˆ†ã‚’è¨å®šã™ã‚‹ã®ã«é©ã—ãŸToDoãƒªã‚¹ãƒˆã‚’è€ƒãˆã¾ã™ã€‚
Gln 2009/04/04
EXCEL

ä»•äº‹è¡“

ã‚¿ã‚¹ã‚¯ç®¡ç†

æ™‚é–“ç®¡ç†

todo
ãƒªãƒ³ã‚¯
æœã®ã†ã¡ã«ã€Œã‚¹ã‚¿ãƒ¡ãƒ³ã‚¿ã‚¹ã‚¯ã€ã¨ã€Œãƒ™ãƒ³ãƒå…¥ã‚Šã‚¿ã‚¹ã‚¯ã€ã‚’æ±ºã‚ã‚‹ã®ã
ã€Œæ™‚é–“é…åˆ†ä»˜ãToDoãƒªã‚¹ãƒˆã€ã¨ã—ã¦å¤§æ©‹ã•ã‚“ãŒãŠã™ã™ã‚ã™ã‚‹ã®ãŒExcelã«ã‚ˆã‚‹ã‚¿ã‚¹ã‚¯ç®¡ç†ã€‚ã€Œã“ã®ä»•äº‹å…¨éƒ¨ã€æœ¬å½“ã«ä»Šæ—¥ä¸ã«çµ‚ã‚ã‚‹ã®ã‹ãªã€ã¨ã„ã†ä¸å®‰ãŒãªããªã‚Šã€çªç„¶äºˆå®šå¤–ã®ã‚¿ã‚¹ã‚¯ãŒå‰²ã‚Šè¾¼ã‚“ã§ããŸã¨ãã«ã‚‚åŠ¹æžœã‚’ç™ºæ®ã—ã¾ã™ã€‚ ã‚¿ã‚¹ã‚¯ã”ã¨ã«æ™‚é–“é…åˆ†ã‚’æ±ºã‚ã‚‹æ®µå–ã‚Šä½œæ¥ã¯ã€æ¯Žæ—¥è¡Œã†ã«ã—ã¦ã‚‚ã‘ã£ã“ã†æ‰‹é–“ã®ã‹ã‹ã‚‹ã‚‚ã®ã ã¨æ€ã„ã¾ã™ã€‚ãã“ã§ä¸€ã¤ææ¡ˆãªã®ã§ã™ãŒã€ç´™ã§ã¯ãªãPCã€ç‰¹ã«Excelã‚’ä½¿ã£ã¦åŒã˜ã‚ˆã†ãªã“ã¨ã‚’ã™ã‚‹ã®ã¯ã„ã‹ãŒã§ã—ã‚‡ã†ã‹ã€‚ ä¾‹ãˆã°ã€Excelã«ä½œæ¥ã‚’æ›¸ãå‡ºã—ã¦ã€å„ä½œæ¥ã®éš£ã®ã‚»ãƒ«ã«æ‰€è¦æ™‚é–“ã‚’è¨˜å…¥ã—ã¾ã™ã€‚Excelã§ã™ã‹ã‚‰ã€æ‰€è¦æ™‚é–“ã®åˆ—ã‚’åˆè¨ˆã™ã‚Œã°ã€ãã®æ—¥ã®ä½œæ¥ã‚’çµ‚ãˆã‚‹ã®ã«å¿…è¦ãªåˆè¨ˆæ™‚é–“ãŒå‰²ã‚Šå‡ºã›ã¾ã™ã€‚ãã®æ™‚é–“ãŒä»®ã«16æ™‚é–“ã‚’è¶…ãˆã¦ã„ã‚Œã°ã€å‡ºç¤¾æ™‚åˆ»ãŒ10æ™‚ãªã‚‰æ·±å¤œ2æ™‚ã¾ã§ä»•äº‹ã‚’ã™ã‚‹ã€ã¨ã„ã†ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ ToDoãƒªã‚¹ãƒˆã ã‘ã§ã¯ã€Œä»Šæ—¥ã¯ä»•äº‹ãŒå¤šã„ãªã€ã¨ã„ã†ç¨‹åº¦ã®èªè˜ã ã£ãŸã®ãŒã€Excelã§æ‰€è¦æ™‚é–“è¾¼
Gln 2009/04/04
ä»•äº‹è¡“

ã‚¿ã‚¹ã‚¯ç®¡ç†

æ™‚é–“ç®¡ç†

todo

EXCEL
ãƒªãƒ³ã‚¯
ã‚¿ã‚¹ã‚¯ã‚·ãƒ¼ãƒˆã§â€œæ™‚é–“ã®ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã‚’åˆ‡ã‚‹â€ã®ã
ã‚¿ã‚¹ã‚¯ã‚’å…¥ã‚Œã‚‹ã¨ã™ãã«ã€Œä»Šæ—¥ã®å¸°å®…æ™‚åˆ»ã€ãŒåˆ†ã‹ã‚‹ã®ã§ã€æœã®æ™‚ç‚¹ã§ã€Œã“ã®ã‚¿ã‚¹ã‚¯ã¯æ˜Žæ—¥ä»¥é™ã«å›žãã†ã€ã¨è¨ˆç”»ã‚’ç«‹ã¦ã‚‰ã‚Œã‚‹ã®ãŒã„ã„ã§ã™ã‚ˆãã€‚ã€Œä»Šæ—¥çµ‚ã‚ã‚‰ãªã‹ã£ãŸã“ã®ä»•äº‹ã€ä»•æ–¹ãªã„ã‘ã©æ˜Žæ—¥ã«å›žãã†â€¦â€¦ã€ã¨ã„ã†ã®ã¨ã€ã€Œï¼ˆæœ€åˆã‹ã‚‰ï¼‰æ˜Žæ—¥ã«å›žã—ã¦ãŠã“ã†ã€ã¨ã„ã†ã®ã§ã¯ã€ã ã„ã¶æ°—æŒã¡ã‚‚å¤‰ã‚ã‚Šã¾ã™ã—ã€‚ ãŸã ã€ä½¿ã£ã¦ã¿ã¦ã¡ã‚‡ã£ã¨ç–‘å•ã«æ€ã£ãŸã®ã¯ã€Œç¤¾å†…ã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ©ãƒ¼ã«ç™»éŒ²ã—ãŸä¼šè°ãªã©ã®äºˆå®šã‚‚ã€ã™ã¹ã¦ã‚¿ã‚¹ã‚¯ã‚·ãƒ¼ãƒˆã«è»¢è¨˜ã™ã¹ããªã®ã ã‚ã†ã‹ï¼Ÿã€ã¨ã„ã†ç‚¹ã§ã™ã€‚ã‚¿ã‚¹ã‚¯ã‚·ãƒ¼ãƒˆã¨ã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ©ãƒ¼ã®ä½¿ã„åˆ†ã‘ã¯ã©ã†ã™ã‚Œã°ã„ã„ã®ã§ã—ã‚‡ã†ï¼Ÿ åŸºæœ¬çš„ã«ã¯ã€ã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ©ãƒ¼ã«ç™»éŒ²ã—ãŸäºˆå®šãªã©ã‚‚è»¢è¨˜ã—ãŸã»ã†ãŒã„ã„ã§ã—ã‚‡ã†ã€‚ç†æƒ³ã¯ã€ã“ã®ã‚·ãƒ¼ãƒˆã«æ›¸ã‹ã‚Œã¦ã„ã‚‹ã‚¿ã‚¹ã‚¯ã•ãˆã‚„ã£ã¦ãŠã‘ã°æ¼ã‚Œã¯ãªã„ã€ã¨ã„ã†çŠ¶æ…‹ã‚’ä½œã‚‹ã“ã¨ã ã‹ã‚‰ã§ã™ã€‚ ã“ã‚Œã¯ã€ã¡ã‚‡ã†ã©â€œæ™‚é–“äºˆç®—ç®¡ç†ã‚·ãƒ¼ãƒˆâ€ã¨ã¨ã‚‰ãˆã‚‹ã¨åˆ†ã‹ã‚Šã‚„ã™ã„ã‹ã¨æ€ã„ã¾ã™ã€‚1æ—¥ã¨ã„ã†æ™‚é–“ã‚’1ã¤ã®HDDã«è¦‹ç«‹ã¦ã¦ã€ã©ã®ã‚ˆã†ã«ãƒ‘
Gln 2009/04/04
lifehacks

todo

ä»•äº‹è¡“

ã‚¿ã‚¹ã‚¯ç®¡ç†

æ™‚é–“ç®¡ç†

EXCEL
ãƒªãƒ³ã‚¯
MatsÃ—DanÃ—Daijiã€Œã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢é€²åŒ–è«–ã€ï½œã€Œã¦ãã‚‰ã¼ã€ã‚ªãƒ¼ãƒ—ãƒ‹ãƒ³ã‚°ã‚¤ãƒ™ãƒ³ãƒˆã€€ã‚¹ãƒšã‚·ãƒ£ãƒ«å¯¾è«‡é–‹å‚¬ï½œãƒ‘ã‚½ãƒŠãƒ†ãƒƒã‚¯ï¼ˆPASONA TECHï¼‰
æ ªå¼ä¼šç¤¾ãƒ‘ã‚½ãƒŠãŒæä¾›ã™ã‚‹ã‚ªã‚¦ãƒ³ãƒ‰ãƒ¡ãƒ‡ã‚£ã‚¢ã‚µã‚¤ãƒˆã§ã™ã€‚
Gln 2008/07/02
EXCEL

æ™‚é–“ç®¡ç†

ä»•äº‹
ãƒªãƒ³ã‚¯
1