|
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..... |
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..... |
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..... |
| All times are GMT +1. The time now is 11:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com