How to input 'Used time' data ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.....
 
THe formula bar will always show that formatting but your cell should show
190:23:00 if you format as [h]:mm:ss
 
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 said:
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.....
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting time...again 2
Finding data between blank rows 2
comparing times in excel 1
Workday Formula to include date 0
Peculiar default cell format 1
time format 4
Grouping/Deleting Dates/Times (HELP ANYONE!) 2
Grouping/Deleting Dates/Times 8

Back
Top