I'm doing something in Excel 2003 which I think is fairly basic. I'm
creating a time entry worksheet function which will be used by administrators
to enter the daily hours for a group of employees. Instead of entering
"8:30", I would like to avoid typing the colon and have the user into "830".
I would then like this to be stored and displayed in the cell as "08:30 AM".
This requires a simple calculation to convert the "830" to the proper time
format, but I can't figure out how to return to the active cell a calculated
value which is calculated based on input from the user. I know there has to
be a way. Any help would be greatly appreciated.
--
CJM