Hi,
I'm working on a timesheet in which users must enter their time in decimals (e.g. 7.50) rather than in hours and minutes (e.g.7:30). To prevent that users enter invalid data, I'm looking for a way to limit the input to fixed decimals (e.g. 7.50 or 6.00 is correct, 7.30 or 6.45 is invalid).
Is this possible in Data Validation ?
The only way I see to do this is by creating a validation list with all possible entries ( 0.50, 1.00, 1.50, 2.00, etc), I hope however that there is a "cleaner" way to do this.
Thanks in advance for your help, much appreciated !
Phill
I'm working on a timesheet in which users must enter their time in decimals (e.g. 7.50) rather than in hours and minutes (e.g.7:30). To prevent that users enter invalid data, I'm looking for a way to limit the input to fixed decimals (e.g. 7.50 or 6.00 is correct, 7.30 or 6.45 is invalid).
Is this possible in Data Validation ?
The only way I see to do this is by creating a validation list with all possible entries ( 0.50, 1.00, 1.50, 2.00, etc), I hope however that there is a "cleaner" way to do this.
Thanks in advance for your help, much appreciated !
Phill