| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time trouble
is it possible to format cell to enter times as example : 12:00, 1:30, 7:30 i figured out how but puts time in as military as in 13:00, 14:30 ect... also anyone have any typing hints on entering times fast? not that i am being lazy although i am, but entering a lot of times when you have to hit shift and find the numbers for the : is a pain... probably doesn't exist but i am looking for a formated cell or something to simplify this task? so maybe then i could just use number pad and hit like 12.3 to = 12:30 or something similiar thanks in advance -- darkbearpooh1 ------------------------------------------------------------------------ darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640 View this thread: http://www.excelforum.com/showthread...hreadid=510439 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time log adding time from separate sheets | New Users to Excel | |||
| Entering Times | Excel Discussion (Misc queries) | |||
| Formula for a time card | Excel Worksheet Functions | |||
| Time To Leave | Excel Discussion (Misc queries) | |||
| Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
Threaded Mode
