Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Time in data validation?
(Using Excel 2002)
I have created a staff timesheet which automatically calculates hours worked etc. etc. The one thing I can't work out is how to use data validation using time. In one cell I have the time the person went on lunch, in the next cell I have the time someone comes back from lunch. I want to make sure that the second value is at least 30 minutes later (i.e. they have to take at least 30 minutes for lunch). How do I achieve this? (In all cells I am using [h]:mm format for time) |
#2
|
|||
|
|||
Assuming the time the individual left for lunch is in A1 and time returned is
in B1, select B1, go to Data Validation, select Custom and use: =$B$1-"00:30"=$A$1 HTH Jason Atlanta, GA "Cymro" wrote: (Using Excel 2002) I have created a staff timesheet which automatically calculates hours worked etc. etc. The one thing I can't work out is how to use data validation using time. In one cell I have the time the person went on lunch, in the next cell I have the time someone comes back from lunch. I want to make sure that the second value is at least 30 minutes later (i.e. they have to take at least 30 minutes for lunch). How do I achieve this? (In all cells I am using [h]:mm format for time) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing Time Data | Excel Discussion (Misc queries) | |||
DATA VALIDATION with LEFT function | Excel Discussion (Misc queries) | |||
Data Validation | Excel Worksheet Functions | |||
data validation | Excel Worksheet Functions | |||
Data Validation | Excel Discussion (Misc queries) |