{"categories":["Excel"],"url":"https://blog.wanichan.net/entry/2016/06/10/143833","width":"100%","author_name":"wanichan","published":"2016-06-10 14:38:33","author_url":"https://blog.hatena.ne.jp/wanichan/","height":"190","provider_name":"Hatena Blog","title":"Excel\u3067\u591c\u52e4\u306e\u5834\u5408\u306e\u52e4\u52d9\u6642\u9593\u306e\u8a08\u7b97\u306e\u4ed5\u65b9","provider_url":"https://hatena.blog","blog_title":"wanichan\u306e\u65e5\u8a18","version":"1.0","description":"\u305f\u3068\u3048\u3070\u591c\u52e4\u30b7\u30d5\u30c8\u306a\u3069\u3001\u7d42\u4e86\u6642\u523b\u304c\u958b\u59cb\u6642\u523b\u3088\u308a\u5024\u304c\u5c11\u306a\u3044\u5834\u5408\u3001\u7d42\u4e86\u6642\u523b\u306b1\u3092\u8db3\u3057\u3001\u305d\u3046\u3067\u306a\u3051\u308c\u3070\u5358\u7d14\u306b\u7d42\u4e86\u6642\u523b\u304b\u3089\u958b\u59cb\u6642\u523b\u3068\u4f11\u61a9\u6642\u9593\u3092\u5dee\u3057\u5f15\u3044\u3066\u8a08\u7b97\u3059\u308b\u3068OK\u3067\u3059\u3002\u7fcc\u671d\u307e\u3067\u52e4\u52d9\u3057\u305f\u5834\u5408\u306f\u305d\u306e\u307e\u307e\u8a08\u7b97\u3057\u3066\u3057\u307e\u3046\u3068\u8ca0\u306e\u5024\u306b\u306a\u3063\u3066\u3057\u307e\u3044\u307e\u3059\u304b\u3089\u306d\u3002 =IF(\u7d42\u4e86\u6642\u523b<\u958b\u59cb\u6642\u523b, \u7d42\u4e86\u6642\u523b+1-\u958b\u59cb\u6642\u523b-\u4f11\u61a9\u6642\u9593,\u7d42\u4e86\u6642\u523b-\u958b\u59cb\u6642\u523b-\u4f11\u61a9\u6642\u9593) \u3061\u306a\u307f\u306b\u3001\u6642\u9593\u306f24\u6642\u9593\u30921\u3068\u3057\u305f\u30b7\u30ea\u30a2\u30eb\u5024\u3067\u3059\u3002\u305d\u3046\u3067\u3059\u3002\u7fcc\u671d\u306f24\u6642\u9593+6\u6642\u306b\u306a\u308b\u306e\u3067\u30011\u3092\u8db3\u305b\u3070OK\u3067\u3059\uff01","type":"rich","image_url":"http://cdn-ak.f.st-hatena.com/images/fotolife/w/wanichan/20160610/20160610143237.png","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fblog.wanichan.net%2Fentry%2F2016%2F06%2F10%2F143833\" title=\"Excel\u3067\u591c\u52e4\u306e\u5834\u5408\u306e\u52e4\u52d9\u6642\u9593\u306e\u8a08\u7b97\u306e\u4ed5\u65b9 - wanichan\u306e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_url":"https://blog.wanichan.net/"}