More than 3 years have passed since last update.

30分単位の切り上げ処理の数式

Salesforce

Last updated at 2021-07-19Posted at 2021-06-30

質問を見て考えていたけど、Apexなら書けそう。
数式では分からん。

でも、回答者が現れるんですねぇ。すごい。

TIMEVALUE(

TEXT(HOUR(TIMEVALUE(CreatedDate))+IF(MINUTE(TIMEVALUE(CreatedDate))>=45,1,0)


)&":"&
IF(AND(MINUTE(TIMEVALUE(CreatedDate))>15, MINUTE(TIMEVALUE(CreatedDate))<45),"30","00")&":00.000")

#15単位の切り上げ処理

ROUND((( Minutes_Field / 60) * 4), 0 ) / 4

これを見ると、上記は下記直せないかな？

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