| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to input 'Used time' data ?
e.g.
I want to input 190 hrs 23 mins, but it show 「07/01/1900 10:23:00 pm」or 「22:23:00」... Can't show「190:23:00」... How can do it? Thank you..... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to input 'Used time' data ?
THe formula bar will always show that formatting but your cell should show
190:23:00 if you format as [h]:mm:ss "Patrick Chan" wrote: e.g. I want to input 190 hrs 23 mins, but it show 「07/01/1900 10:23:00 pm」or 「22:23:00」... Can't show「190:23:00」... How can do it? Thank you..... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to input 'Used time' data ?
thx
but after I input this data, when I double-click the cell to change the data, it always show 「07/01/1900 10:23:00 pm」.... daddylonglegs编写： THe formula bar will always show that formatting but your cell should show 190:23:00 if you format as [h]:mm:ss "Patrick Chan" wrote: e.g. I want to input 190 hrs 23 mins, but it show 「07/01/1900 10:23:00 pm」or 「22:23:00」... Can't show「190:23:00」... How can do it? Thank you..... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Prevent Duplicate Data from inputing using input application? | Excel Worksheet Functions | |||
| How to Prevent Duplicate Data from inputing using input application? | New Users to Excel | |||
| Convert data into standard military time format | Excel Discussion (Misc queries) | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Linear Mode
