Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
I am having the data entry clerk entering time in military form (ex: 1330 = 1:30pm), but I do not want the last two digits to go over 60 at anytime. Can anyone help? Is there a function in excel that will do military time? Thanks. -- exsam21 ------------------------------------------------------------------------ exsam21's Profile: http://www.excelforum.com/member.php...o&userid=22666 View this thread: http://www.excelforum.com/showthread...hreadid=502516 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
You could use a custom data validation as follows:- (assuming the data is going into A1 - adjust A1 if this is not the case) =IF(VALUE(RIGHT(A1,2))60,FALSE,TRUE) You may want to expand this to validate the hours as well, so that you can't enter a number greater than 23. -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=502516 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
Thank you very much. -- exsam21 ------------------------------------------------------------------------ exsam21's Profile: http://www.excelforum.com/member.php...o&userid=22666 View this thread: http://www.excelforum.com/showthread...hreadid=502516 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Data Validation | Excel Worksheet Functions | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |