| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time
I am hopeless today just cant seem to get the cell to read in 24 hour time.
if i type in 2030 it will show the date and 1200.am How can I fix this I have tried the custom controls, just cant work it out Thanks Greg |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Time
not clear. however try typing
20:30 ---note the colon and fromat as time-13:30 mine excel 2000 Greg Brow wrote in message ... I am hopeless today just cant seem to get the cell to read in 24 hour time. if i type in 2030 it will show the date and 1200.am How can I fix this I have tried the custom controls, just cant work it out Thanks Greg |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Time
Thankyou will now post in the beginners forum. I just could not think of
that. Greg "R.VENKATARAMAN" $$$ wrote in message ... not clear. however try typing 20:30 ---note the colon and fromat as time-13:30 mine excel 2000 Greg Brow wrote in message ... I am hopeless today just cant seem to get the cell to read in 24 hour time. if i type in 2030 it will show the date and 1200.am How can I fix this I have tried the custom controls, just cant work it out Thanks Greg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time calculations for Scheduled Time vs. Actual Time Worked | Excel Discussion (Misc queries) | |||
| straight time, time and a half, and double time | Excel Discussion (Misc queries) | |||
| Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
| verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Hybrid Mode
