Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Time: 11.45 = 11:45
Is there a way to be able to type it in a number (i.e. 11.45) and have it
display as a time (11:45)? When I format the cell to display as time I have to type the hour, a colon, and minutes. Is there any way around this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time differences in a column | Excel Worksheet Functions | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
Time Sheets | Excel Discussion (Misc queries) | |||
unmet challenge | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |