Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Denise
 
Posts: n/a
Default Entering Times

I have a spreadsheet that has the following columns:

Arrival Time Triage Time To ED Time Saw MD Time Discharge Time

I have about 15 people entering data in this worksheet at different times.
There a a few that can't quite get the numbers entered right - example.

The patient will arrive at 10:30 but they may enter a time that they were
taken to the ED at 8:30 - two hours before they are even here!! I have
talked to these people and told them that they need to watch the times that
they are entering and make sure that they are accurate.

Is there a code/way to set the worksheet up so that if they enter a time
that is wrong it won't let them enter. I have tried Validation - time -
allow greater than or = to. That won't work.

Thanks for any help.
 
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
after entering certain number of times wrong password file can cur Rao Ratan Singh Excel Discussion (Misc queries) 1 August 28th 05 04:51 PM
Entering Times Denise Excel Discussion (Misc queries) 1 July 26th 05 06:47 PM
entering times automaticly George Excel Discussion (Misc queries) 2 May 6th 05 03:18 PM
Charting and analyzing Times' times data for trends Johnny Excel Discussion (Misc queries) 1 May 5th 05 01:36 AM
SUMPRODUCT ON TIMES Bob Phillips Excel Worksheet Functions 1 January 13th 05 05:28 PM


All times are GMT +1. The time now is 06:02 PM.

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

About Us

"It's about Microsoft Excel"