Time in hh:mm on a field in form

(0) Share

Report

Posted on by Eisenberk

Hello,

I am making a form that contains a field in which hours and minutes are entered. In this field I want to enter weekly hours, therefore a number of hours greater than 24. But, I want to respect that the minutes do not exceed 60. For example, 60 hours and a half, it should be 60:30 instead of 60:50.

I can't find any dataype that meets the requirement, the closest one is TimeHour24 but it doesn't support values greater than 24. I have thought about using strings but I don't think it is the best idea to make calculations.

Any advice?

Thanks.

All responses (3)

Answers (1)

Eisenberk 87 on at

Like (0)

Report

RE: Time in hh:mm on a field in form

Thanks Martin, I used a String, then validated it with Regex.
Deepak Agarwal 8,566 on at

Like (1)

Report

RE: Time in hh:mm on a field in form

Hello,

You can try to use a real data time along with a help text which may say an example of entering data like 60.50 instead of 60.30 or vise versa, and validate the value. You can explore Project timesheet form.
Verified answer

Martin Dráb 231,409 Most Valuable Professional on at

Like (1)

Report

RE: Time in hh:mm on a field in form

I suspect that you'll indeed need to use a string. It might be a string display method validating the data and saving it as a numeric field under the hood.

You could also create a custom control, but I wouldn't do it. While it might do a great job at the moment, you won't be able to upgrade it to F&O.