Hi Guys,

I wanted to enter a data validation for a column in a spreadsheet I am designing.

The problem is; if I use the Time in the 'Allow' combo box and then between in the 'Data' combo box, I set the start time as 0:00 and I wanted to set the end time as 999:00 as I am dealing with total hours worked and not hours within 24 hours if you get what I mean.

The problem is sometimes I need to enter large hours such as 521 hours for example.

Is there a way that I can set maybe a wildcard format so that as long as the time format is h:mm it will accept it.

The Time cell is formatted as: [h]:mm.

My second problem is with dates. I have another sheet on the spreadsheet for checking vacancies. in the first column is 'Date from' and the second column is 'Date to' for the required vacancy for temp staff. The third column then calculates how many weeks the temp member of staff is needed by simply subtracting the 'Date from' from 'Date to'.

I wanted a Validation in the 'Date to' column so that if a date is entered that is lower than the 'Date from' date then it will flag up an error as I don't want to be dealing with negative dates.

How can I achieve this?

Thanks in advance for any help offered.