No. | ¼ÁÌ䡦²óÅú | ¤ª¤ì¤¤ |
|
[87417] Excel¤Ç»Ä¶È»þ´Ö´ÉÍý¤¬¤·¤¿¤¤¤Î¤Ç¤¹¤¬¡¦¡¦¡¦ |
|
|
OS: Windows XP
Office¡§2003
¥¨¥¯¥»¥ë¤Ç18»þ°Ê¹ß¤Î»Ä¶È»þ´Ö¤ò´ÉÍý¤¹¤ë¤³¤È¤Ë¤Ê¤ê¤Þ¤·¤¿¡£
»Ä¶È»þ´Öɽ¼¨¤Ï¡¢18»þ°Ê¹ß30ʬ¹ï¤ß¤Ç¡¢
18»þ30ʬ¤Çµ¢Â𤷤¿¾ì¹ç¡¢0¡¥5¤Èɽ¼¨¡£
19»þ¤Çµ¢Â𤷤¿¾ì¹ç¡¢1¤Èɽ¼¨¡£
20»þ15ʬ¤Çµ¢Â𤷾ì¹ç¡¢2¤Èɽ¼¨¡£
20»þ31ʬ¤Çµ¢Â𤷤¿¾ì¹ç¡¢2¡¥5¤Èɽ¼¨¡£
21»þ¤Çµ¢Â𤷤¿¾ì¹ç¡¢3¤Èɽ¼¨¡£
21»þ59ʬ¤Çµ¢Â𤷤¿¾ì¹ç¡¢3¡¥5¤Èɽ¼¨¡£
22»þ¤Çµ¢Â𤷤¿¾ì¹ç¡¢4¤Èɽ¼¨¡£
²¼µ¤Î¤è¤¦¤ËºîÀ®¤·¤¿¤¤¤Î¤Ç¤¹¤¬¡¢¤É¤Ê¤¿¤«¤ªÊ¬¤«¤ê¤ÎÊý¡¢¶µ¤¨¤Æ¤¯¤À¤µ¤¤¡£
¡¡¡¡¡¡¡¡¡¡¡¡10/13¡¡¡¡¡¡10/14¡¡¡¡¡¡¡Á
¼Ò°÷A¡¡¡¡¡¡¡¡18:00 19:00
»Ä¶È»þ´Ö¡¡¡¡ 0 1
¼Ò°÷B 18:30 19:31
»Ä¶È»þ´Ö 0.5 1.5
¼Ò°÷C 22:20 20:29
»Ä¶È»þ´Ö 4 2
¼Ò°÷D¡¡ 24:01 21:59
»Ä¶È»þ´Ö 6 3.5
¤É¤Î¤è¤¦¤Ê´Ø¿ô¤ò¤¤¤ì¤ì¤Ð¤¤¤¤¤Ç¤·¤ç¤¦¤«¡©
¤É¤¦¤¾µ¹¤·¤¯¤ª´ê¤¤¤¤¤¿¤·¤Þ¤¹¡£
¤ß¤Ê¤È 2006ǯ10·î13Æü11:44
|
|
|
|
[87418] |
µÙ·Æ»þ´Ö¤Ï¹Íθ¤·¤Ê¤¯¤Æ¤¤¤¤¤è¤¦¤Ê¤Î¤Ç¡Ä¡£
¤Þ¤º¤Ï´ðËܤǡ¢18:00¤È¤Îº¹¤Ë1440¤ò¤«¤±¤ë¤³¤È¤Ç¡¢º¹¤òʬ¤Çɽ¤¹¤³¤È¤¬¤Ç¤¤Þ¤¹¡£
¡Ê¥Ø¥ë¥×¡Ö2 ¤Ä¤Î»þ¹ï´Ö¤Îº¹Ê¬¤ò·×»»¤¹¤ë¡×¤ò»²¾È¡Ë
¤½¤ì¤ò30¤Ç³ä¤Ã¤Æ¾®¿ôÅÀ°Ê²¼¤òÀÚ¤ê¼Î¤Æ¡¢¤µ¤é¤Ë2¤Ç³ä¤ì¤ÐÎɤ¤¤Ç¤¹¡£
mio (107) 2006ǯ10·î13Æü12:28
|
|
|
|
[87420] |
¶ñÂÎŪ¤Ë¤Ï¶Ð̳½ªÎ»»þ¹ï¤ò¡ÖA1¡×¤È¤¹¤ë¤È¡¢
=FLOOR(A1*24-18,0.5)
¡ÖA1*24¡×¤Ç¡¢»þ¹ï¥Ç¡¼¥¿¤ò¡Ö»þ´Ö¡×¤Î¿ôÃͤËÊÑ´¹¤·¡¢
»Ä¶È·×»»µ¯ÅÀ¤Î¡Ö18¡×»þ¤ò¹µ½ü¤¹¤ë¤È»Ä¶È¡Ö»þ´Ö¡×¤¬½Ð¤Þ¤¹¡£
¤½¤Î¾å¤Ç¡Ö0.5¡×ñ°Ì¤ÇÃͤòÀÚ¤ê¼Î¤Æ¤ì¤Ð¥ª¥Ã¥±¡¼¤«¤È¡£
¤¿¤À¡¢¤³¤Î¼°¤À¤È18:00¡Á18:29¤Ëµ¢¤Ã¤¿¾ì¹ç¤Ë¡Ö0¡×»þ´Ö¤Ë¤Ê¤ê¤Þ¤¹¡£
¤³¤¦¤¤¤¦¤Î¤Ã¤Æ¡¢Ë¡Åª¤Ë¤Ê¤ó¤À¤«¤Þ¤º¤½¤¦¤Êµ¤¤¬¤¹¤ë¤Î¤Ç¤¹¤¬¡¦¡¦¡¦¡£
mory (512) 2006ǯ10·î13Æü12:54
|
|
|
|
[87422] |
¤´²óÅú¡¢¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£
¤ä¤Ã¤Æ¤ß¤Þ¤·¤¿¤¬¡¢²¼µ¤Î¤è¤¦¤Ê·×»»·ë²Ì¤Ë¤Ê¤ê¤Þ¤·¤¿¡£
¤Ê¤¼¤Ç¤·¤ç¤¦¡¢¥¨¥¯¥»¥ë¤Î¥Ð¥°¤Ç¤·¤ç¤¦¤«¡©
¡
A1 18:00
A2¡¡ 19:57
A3¡¡ 2808:00:00 (¼°¡¡(A2-A1)*1440)
A4 4 (¼°¡¡A3/30)
A5¡¡¡¡¡¡¡¡¡¡2.0 ¡Ê¼°¡¡A4/2¡Ë¡¡¡¡¡¡¡¡¡¡·ë²Ì
Ƴ¤¤¿¤¤·ë²Ì¤Ï¡¢1¡¥5¤Ê¤Î¤Ç¤¹¡£
²¼¤ÎÆó¤Ä¤âƱ·ë²Ì¤Ç¤¹¡£
¡¡¡¡¡¡¡¡ ¢ ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£
A1¡¡¡¡18:00:00¡¡¡¡¡¡ 18:00:00
A2¡¡¡¡19:58:00 ¡¡¡¡¡¡¡¡ 22:29:00
A3¡¡¡¡2832:00:00¡¡¡¡ 6456:00:00
A4¡¡¡¡¡¡¡¡¡¡4 ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ 9
A5¡¡¡¡¡¡¡¡¡¡2.0 ¡¡¡¡¡¡¡¡¡¡¡¡¡¡4.5
Ƴ¤¤¿¤¤·ë²Ì¤Ï¡¢¢1¡¥5¡¡¤È¡¡£4¡¥0¤Ê¤Î¤Ç¤¹¡£
¤³¤Î¤è¤¦¤Ë¤¹¤ë°Ù¤Ë¤Ï¡¢¤É¤¦¤·¤¿¤é¤¤¤¤¤Ç¤·¤ç¤¦¤«¡©
¤¹¤ß¤Þ¤»¤ó¤¬¡¢¤è¤í¤·¤¯¤ª¤Í¤¬¤¤¤·¤Þ¤¹¡£
¤ß¤Ê¤È 2006ǯ10·î13Æü13:57
|
|
|
|
[87423] |
moryÍÍ
¤ª¤ª¤ª¡¼¡¼¡¼¡¼¡¢¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£
¤³¤ó¤Ê¤Ë´Êñ¤Ë¤Ç¤¤Æ¤·¤Þ¤¦¤È¤Ï¡£
¤È¤Æ¤â½õ¤«¤ê¤Þ¤·¤¿¡£
¤Á¤Ê¤ß¤Ë18:00¡Á18:29¤Ç¡¢0»þ´Ö¤Ë¤Ê¤Ã¤Æ¤·¤Þ¤¦¤Î¤Ï¡¢
²ñ¼ÒŪ¤Ë¤ÏÌäÂê¤Ê¤¤¤½¤¦¤Ç¤¹¡£
¤ª¤«¤·¤ÊÏäǤ¹¤Í¡£
¤ß¤Ê¤È 2006ǯ10·î13Æü14:01
|
|
|
|
[87425] |
°ì±þ½ñ¤¤¤Æ¤ª¤¤Þ¤¹¡£
>¾®¿ôÅÀ°Ê²¼¤òÀÚ¤ê¼Î¤Æ
¤È¤¤¤¦°ìʸ¤ò¡¢¸«Íî¤È¤·¤Æ¤¤¤ë¤è¤¦¤Ç¤¹¡£
°Â°×¤Ë¥Ð¥°¤òµ¿¤Ã¤Æ¤Ï¤¤¤±¤Þ¤»¤ó¡£
mio (107) 2006ǯ10·î13Æü14:15
|
|
|
|
( »²¾È¿ô:2846 ÆüÊ¿¶Ñ:0.4 ) |
|
¡Á¡¡²óÅú¤Î¼õÉÕ¤ò½ªÎ»¤·¤Þ¤·¤¿¡¡¡Á |