| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Take a 3 or for digit time and convet it to time in one cell
I'm trying to take just one cell and set it up to display a time. it someone
entered 330 I need the cell to display 3:30. When no time is entered in it can display 0:00 for the time. I have tried clicking on time in the number drop down. It shows 0:00 then I type in 930. when I hit enter it returns 0:00. If I click on the ceel it displays a date and time. All I want in the cell is the time to show if it is entered 930. Can any one help me. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement to compare time cell to a time | Excel Worksheet Functions | |||
| Custom Formatting, for 8 digit time (timecode) | Excel Discussion (Misc queries) | |||
| Extracting Time from a cell that has both the date and the time | Excel Discussion (Misc queries) | |||
| Adding time to date-time formatted cell | Excel Discussion (Misc queries) | |||
| how do i type a time into a cell formatted for time? | Excel Discussion (Misc queries) | |||
Threaded Mode
