Time validation query

P

Papa

Hi Guys,

Firstly thanks to everyone for helping me on my earlier
query about adding minutes.

But I need more help with the following query to help
validate my earlier question

1) Users enter their overtime in hours and minutes the
cell format is a custom H:MM
2) I try and validate their input by going to DATA |
VALIDATION | ALLOW | CUSTOM | and custom = H:MM

For some reason this will not work. Does anybody know
how to get this working?

Many Thanks,
Papa
 
Top