LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Cymro
 
Posts: n/a
Default 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)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summing Time Data AJG Excel Discussion (Misc queries) 3 May 13th 05 08:44 PM
DATA VALIDATION with LEFT function Gabe Excel Discussion (Misc queries) 2 May 6th 05 06:37 PM
Data Validation gbeard Excel Worksheet Functions 1 May 3rd 05 09:09 AM
data validation gbeard Excel Worksheet Functions 2 May 2nd 05 09:57 PM
Data Validation peterm Excel Discussion (Misc queries) 15 March 3rd 05 01:26 PM


All times are GMT +1. The time now is 10:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"