Has anyone been able to create caladdminutes function? Been searching in availab

Jess over 10 years ago

Has anyone been able to create caladdminutes function? Been searching in available plugins but to no success..

Discussion posts and replies are publicly visible

Parents

0 mahipalc over 10 years ago

hi jessicae,
Can you create a rule with below code:
=time(hour(ri!input)+floor((minute(ri!input)+ri!addMinutes)/60),mod((minute(ri!input) + ri!addMinutes),60)).
Here i/p's are
"input" of type time, "addMinutes" of type integer.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 mahipalc over 10 years ago

hi jessicae,
Can you create a rule with below code:
=time(hour(ri!input)+floor((minute(ri!input)+ri!addMinutes)/60),mod((minute(ri!input) + ri!addMinutes),60)).
Here i/p's are
"input" of type time, "addMinutes" of type integer.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data