0

I have created a time entry form using a SharePoint list and InfoPath. One of the requirements is a column called 'Time spent' where they are to input the amount of time they spent on a project. It was requested in this format: HH.MM – 15 minute increments. The column type is currently a Number, and they do not wish to ask for date/time ranges.

Could anyone please offer some advice on a way to approach this? I am open to trying column validation through SharePoint or using rules in InfoPath.

I am using SharePoint Online 2016 and InfoPath 2013.

Thanks!

1

Maybe something like this?

=TRUNC(MOD((Number-TRUNC(Number))*100,15))=0

Number-TRUNC(Number) returns the decimal part

Multiply that by 100 to get it in whole numbers

Do a MOD 15 statement against that, the remainder should be 0. The final trunc is to get around decimal precision problems.

  • This works beautifully. Thank you for taking the time to help and explaining your answer. – Madeline Schimenti Jul 13 '17 at 20:43
  • I overlooked this, but it should be =TRUNC(MOD((Number-TRUNC(Number))*100,25))=0 to convert the hour to decimal. (15 minutes, quarter hour) – Madeline Schimenti Jul 19 '17 at 12:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.