絵文字時計 kintone

nakaji32さんがkintoneで絵文字をつかって面白いことやってくださいました！

さっそく思いついたこと。「時刻」フィールドの値を、「文字列 (1行)」フィールドの自動計算で受けてIF関数で「絵文字時計」を作ってみました。

nakaji32さん、面白いアイデアありがとうございました！

nakaji32さんのnoteコメントに貼ろうと思いましたが、さすがに文字数制限でできなかったので😅、サクッとnoteに書きました。

絵文字時計

関数

関数はこんな感じ（絵文字ちゃんとあってるかな？😅）

IF(時刻<=60*60*00+0000,"🕛",
IF(時刻<=60*60*00+1800,"🕧",
IF(時刻<=60*60*01+0000,"🕐",
IF(時刻<=60*60*01+1800,"🕜",
IF(時刻<=60*60*02+0000,"🕑",
IF(時刻<=60*60*02+1800,"🕝",
IF(時刻<=60*60*03+0000,"🕒",
IF(時刻<=60*60*03+1800,"🕞",
IF(時刻<=60*60*04+0000,"🕓",
IF(時刻<=60*60*04+1800,"🕟",
IF(時刻<=60*60*05+0000,"🕔",
IF(時刻<=60*60*05+1800,"🕠",
IF(時刻<=60*60*06+0000,"🕕",
IF(時刻<=60*60*06+1800,"🕡",
IF(時刻<=60*60*07+0000,"🕖",
IF(時刻<=60*60*07+1800,"🕢",
IF(時刻<=60*60*08+0000,"🕗",
IF(時刻<=60*60*08+1800,"🕣",
IF(時刻<=60*60*09+0000,"🕘",
IF(時刻<=60*60*09+1800,"🕤",
IF(時刻<=60*60*10+0000,"🕙",
IF(時刻<=60*60*10+1800,"🕥",
IF(時刻<=60*60*11+0000,"🕚",
IF(時刻<=60*60*11+1800,"🕦",
IF(時刻<=60*60*12+0000,"🕛",
IF(時刻<=60*60*12+1800,"🕧",
IF(時刻<=60*60*13+0000,"🕐",
IF(時刻<=60*60*13+1800,"🕜",
IF(時刻<=60*60*14+0000,"🕑",
IF(時刻<=60*60*14+1800,"🕝",
IF(時刻<=60*60*15+0000,"🕒",
IF(時刻<=60*60*15+1800,"🕞",
IF(時刻<=60*60*16+0000,"🕓",
IF(時刻<=60*60*16+1800,"🕟",
IF(時刻<=60*60*17+0000,"🕔",
IF(時刻<=60*60*17+1800,"🕠",
IF(時刻<=60*60*18+0000,"🕕",
IF(時刻<=60*60*18+1800,"🕡",
IF(時刻<=60*60*19+0000,"🕖",
IF(時刻<=60*60*19+1800,"🕢",
IF(時刻<=60*60*20+0000,"🕗",
IF(時刻<=60*60*20+1800,"🕣",
IF(時刻<=60*60*21+0000,"🕘",
IF(時刻<=60*60*21+1800,"🕤",
IF(時刻<=60*60*22+0000,"🕙",
IF(時刻<=60*60*22+1800,"🕥",
IF(時刻<=60*60*23+0000,"🕚",
IF(時刻<=60*60*23+1800,"🕦",
"🕛")
)))))))))))))))))))))))))))))))))))))))))))))))