Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
What's the right time? If you use the built in clock you can set validation
within a few minutes of that time, datavalidationallowcustom =AND(D1<=TIME(,10,)+MOD(NOW(),1),D1=MOD(NOW(),1)-TIME(,10,)) where D1 would be the cell where the time entry is made you can setup your own validation message Incorrect Time! Please check your watch again! :) -- Regards, Peo Sjoblom "Denise" wrote in message ... 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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Actually that won't work. The times may not be entered until a few hours or
even the next day. "Peo Sjoblom" wrote: What's the right time? If you use the built in clock you can set validation within a few minutes of that time, datavalidationallowcustom =AND(D1<=TIME(,10,)+MOD(NOW(),1),D1=MOD(NOW(),1)-TIME(,10,)) where D1 would be the cell where the time entry is made you can setup your own validation message Incorrect Time! Please check your watch again! :) -- Regards, Peo Sjoblom "Denise" wrote in message ... 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. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
So how would you expect to validate the times if there are no set rules?
-- Regards, Peo Sjoblom "Denise" wrote in message ... Actually that won't work. The times may not be entered until a few hours or even the next day. "Peo Sjoblom" wrote: What's the right time? If you use the built in clock you can set validation within a few minutes of that time, datavalidationallowcustom =AND(D1<=TIME(,10,)+MOD(NOW(),1),D1=MOD(NOW(),1)-TIME(,10,)) where D1 would be the cell where the time entry is made you can setup your own validation message Incorrect Time! Please check your watch again! :) -- Regards, Peo Sjoblom "Denise" wrote in message ... 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. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am not sure what you mean. I am looking for a formula or something so that
when they type in an incorrect time (the patient was taken to a room before they got here) it will alert them and they will catch their typing mistake. I have formulas to figure wait times, etc. and when a time is typed in wrong it messes up the times that I am trying to capture. All of the times come from the patient chart when they are turned in to the secretary to enter in the computer. Sometimes a time is written wrong or typed in wrong. The secretaries enter the time no matter what. "Peo Sjoblom" wrote: So how would you expect to validate the times if there are no set rules? -- Regards, Peo Sjoblom "Denise" wrote in message ... Actually that won't work. The times may not be entered until a few hours or even the next day. "Peo Sjoblom" wrote: What's the right time? If you use the built in clock you can set validation within a few minutes of that time, datavalidationallowcustom =AND(D1<=TIME(,10,)+MOD(NOW(),1),D1=MOD(NOW(),1)-TIME(,10,)) where D1 would be the cell where the time entry is made you can setup your own validation message Incorrect Time! Please check your watch again! :) -- Regards, Peo Sjoblom "Denise" wrote in message ... 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. |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How would you know a typed time is wrong? That is whhat I mean by rules, to
be able to not allow somebody to type a certain time you have to know the typed time in incorrect? -- Regards, Peo Sjoblom "Denise" wrote in message ... I am not sure what you mean. I am looking for a formula or something so that when they type in an incorrect time (the patient was taken to a room before they got here) it will alert them and they will catch their typing mistake. I have formulas to figure wait times, etc. and when a time is typed in wrong it messes up the times that I am trying to capture. All of the times come from the patient chart when they are turned in to the secretary to enter in the computer. Sometimes a time is written wrong or typed in wrong. The secretaries enter the time no matter what. "Peo Sjoblom" wrote: So how would you expect to validate the times if there are no set rules? -- Regards, Peo Sjoblom "Denise" wrote in message ... Actually that won't work. The times may not be entered until a few hours or even the next day. "Peo Sjoblom" wrote: What's the right time? If you use the built in clock you can set validation within a few minutes of that time, datavalidationallowcustom =AND(D1<=TIME(,10,)+MOD(NOW(),1),D1=MOD(NOW(),1)-TIME(,10,)) where D1 would be the cell where the time entry is made you can setup your own validation message Incorrect Time! Please check your watch again! :) -- Regards, Peo Sjoblom "Denise" wrote in message ... 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. |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If a person walks through our doors at 9:00 they can't go to a room at 8:30.
Most of the time it is a simple typing error or inability to read the nurses hand writing. When it is entered like this the formula shows a negative result. "Peo Sjoblom" wrote: How would you know a typed time is wrong? That is whhat I mean by rules, to be able to not allow somebody to type a certain time you have to know the typed time in incorrect? -- Regards, Peo Sjoblom "Denise" wrote in message ... I am not sure what you mean. I am looking for a formula or something so that when they type in an incorrect time (the patient was taken to a room before they got here) it will alert them and they will catch their typing mistake. I have formulas to figure wait times, etc. and when a time is typed in wrong it messes up the times that I am trying to capture. All of the times come from the patient chart when they are turned in to the secretary to enter in the computer. Sometimes a time is written wrong or typed in wrong. The secretaries enter the time no matter what. "Peo Sjoblom" wrote: So how would you expect to validate the times if there are no set rules? -- Regards, Peo Sjoblom "Denise" wrote in message ... Actually that won't work. The times may not be entered until a few hours or even the next day. "Peo Sjoblom" wrote: What's the right time? If you use the built in clock you can set validation within a few minutes of that time, datavalidationallowcustom =AND(D1<=TIME(,10,)+MOD(NOW(),1),D1=MOD(NOW(),1)-TIME(,10,)) where D1 would be the cell where the time entry is made you can setup your own validation message Incorrect Time! Please check your watch again! :) -- Regards, Peo Sjoblom "Denise" wrote in message ... 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. |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Denise, would Conditional Formatting work? For example, if Arrival Time is
in A2 and Triage Time is in B2, you could enter in Conditional Formatting for B2 -- Cell Value is less than =A2 and format it red and bold. This would at least make the data entry person aware that there is a problem with the Triage Time entry. -- Sincerely, Michael Colvin "Denise" wrote: I am not sure what you mean. I am looking for a formula or something so that when they type in an incorrect time (the patient was taken to a room before they got here) it will alert them and they will catch their typing mistake. I have formulas to figure wait times, etc. and when a time is typed in wrong it messes up the times that I am trying to capture. All of the times come from the patient chart when they are turned in to the secretary to enter in the computer. Sometimes a time is written wrong or typed in wrong. The secretaries enter the time no matter what. "Peo Sjoblom" wrote: So how would you expect to validate the times if there are no set rules? -- Regards, Peo Sjoblom "Denise" wrote in message ... Actually that won't work. The times may not be entered until a few hours or even the next day. "Peo Sjoblom" wrote: What's the right time? If you use the built in clock you can set validation within a few minutes of that time, datavalidationallowcustom =AND(D1<=TIME(,10,)+MOD(NOW(),1),D1=MOD(NOW(),1)-TIME(,10,)) where D1 would be the cell where the time entry is made you can setup your own validation message Incorrect Time! Please check your watch again! :) -- Regards, Peo Sjoblom "Denise" wrote in message ... 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. |
#9
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I could do that but my concern is that the secretaries have so much
information that they have to enter that it would still be over looked. Is there a way that when an time is not right that it will stop them and have them verify the time? "Michael" wrote: Denise, would Conditional Formatting work? For example, if Arrival Time is in A2 and Triage Time is in B2, you could enter in Conditional Formatting for B2 -- Cell Value is less than =A2 and format it red and bold. This would at least make the data entry person aware that there is a problem with the Triage Time entry. -- Sincerely, Michael Colvin "Denise" wrote: I am not sure what you mean. I am looking for a formula or something so that when they type in an incorrect time (the patient was taken to a room before they got here) it will alert them and they will catch their typing mistake. I have formulas to figure wait times, etc. and when a time is typed in wrong it messes up the times that I am trying to capture. All of the times come from the patient chart when they are turned in to the secretary to enter in the computer. Sometimes a time is written wrong or typed in wrong. The secretaries enter the time no matter what. "Peo Sjoblom" wrote: So how would you expect to validate the times if there are no set rules? -- Regards, Peo Sjoblom "Denise" wrote in message ... Actually that won't work. The times may not be entered until a few hours or even the next day. "Peo Sjoblom" wrote: What's the right time? If you use the built in clock you can set validation within a few minutes of that time, datavalidationallowcustom =AND(D1<=TIME(,10,)+MOD(NOW(),1),D1=MOD(NOW(),1)-TIME(,10,)) where D1 would be the cell where the time entry is made you can setup your own validation message Incorrect Time! Please check your watch again! :) -- Regards, Peo Sjoblom "Denise" wrote in message ... 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. |
#10
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Yes I understand that but is the time documented anywhere so you can compare
with what they enter? If not is is obviosuly not possible since you need something to validate against -- Regards, Peo Sjoblom "Denise" wrote in message ... If a person walks through our doors at 9:00 they can't go to a room at 8:30. Most of the time it is a simple typing error or inability to read the nurses hand writing. When it is entered like this the formula shows a negative result. "Peo Sjoblom" wrote: How would you know a typed time is wrong? That is whhat I mean by rules, to be able to not allow somebody to type a certain time you have to know the typed time in incorrect? -- Regards, Peo Sjoblom "Denise" wrote in message ... I am not sure what you mean. I am looking for a formula or something so that when they type in an incorrect time (the patient was taken to a room before they got here) it will alert them and they will catch their typing mistake. I have formulas to figure wait times, etc. and when a time is typed in wrong it messes up the times that I am trying to capture. All of the times come from the patient chart when they are turned in to the secretary to enter in the computer. Sometimes a time is written wrong or typed in wrong. The secretaries enter the time no matter what. "Peo Sjoblom" wrote: So how would you expect to validate the times if there are no set rules? -- Regards, Peo Sjoblom "Denise" wrote in message ... Actually that won't work. The times may not be entered until a few hours or even the next day. "Peo Sjoblom" wrote: What's the right time? If you use the built in clock you can set validation within a few minutes of that time, datavalidationallowcustom =AND(D1<=TIME(,10,)+MOD(NOW(),1),D1=MOD(NOW(),1)-TIME(,10,)) where D1 would be the cell where the time entry is made you can setup your own validation message Incorrect Time! Please check your watch again! :) -- Regards, Peo Sjoblom "Denise" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
after entering certain number of times wrong password file can cur | Excel Discussion (Misc queries) | |||
Entering Times | Excel Discussion (Misc queries) | |||
entering times automaticly | Excel Discussion (Misc queries) | |||
Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
SUMPRODUCT ON TIMES | Excel Worksheet Functions |