Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Correcting time input by users
I have a worksheet where employees will be entering in times. I do
caculations based on these times and I would like a way so if the user enters inthe time like "10:00pm" that excel will correct it to display "10:00 pm". Is there a way to check for this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I set up an input calendar for users in excel | Excel Discussion (Misc queries) | |||
Select a range of data dependant on the users input ie dates | Excel Discussion (Misc queries) | |||
using an input box to allow users type in the differnt fields name | Excel Programming | |||
can you input time (hh:mm:ss) without having to input the colon i. | Excel Discussion (Misc queries) | |||
Please need HELP - Need to add and INPUT BOX so that users need to enter a PASSWORD to use a workbook | Excel Programming |