Post

2 followers Follow
0
Avatar

Force Time to be captured in Hours

what would a Validation Rule look like if we want time to captured in hours - ie:  hours only - not minutes ?

 

we already have a validation rule in place to force things to be entered in 15 minute increments - we want to enhance this to not only enforce the 15 minute rule - but also enforce time to be entered in hours only

 

Mod($Duration/Hours(1)*60,15)<>0

Dean Broking Answered

Please sign in to leave a comment.

1 comment

0
Avatar

You could force users to enter time via a custom action that accepts only a number and then converts that to a duration field.

Josh Santos 0 votes
Comment actions Permalink