Notion数式で分数を時刻文字列に変換

Notion

Last updated at 2024-05-12Posted at 2024-05-12

常に"H:MM:SS"の場合

lets(
	h, floor(prop("分") / 3600),
	m, floor(mod(prop("分"), 3600) / 60),
	s, mod(prop("分"), 60),
	h + ":" + (m < 10 ? "0" : "") + m + ":"  + (s < 10 ? "0" : "") + s
)

１時間未満なら"M:SS"の場合

lets(
	h, floor(prop("分") / 3600),
	m, floor(mod(prop("分"), 3600) / 60),
	s, mod(prop("分"), 60),
	(h ? h + ":": "") + (h && m < 10 ? "0" : "") + m + ":"  + (s < 10 ? "0" : "") + s
)

１分未満なら"S"の場合

lets(
	h, floor(prop("分") / 3600),
	m, floor(mod(prop("分"), 3600) / 60),
	s, mod(prop("分"), 60),
	(h ? h + ":": "") + (h || m ? (h && m < 10 ? "0" : "") + m + ":" : "") + ((h || m) && s < 10 ? "0" : "") + s
)

参考

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up