Snippets home page
 
 
register
 
 
computer

Can you put the decimal number in hh:mm format while working in excel?

I need help with excell.

asked by nleitere (18)

You have 50 words left!
 
 
related questions

How can I collapse rows in excel?

How do you make a new line character in a Microsoft Excel cell?

Can a number counter be created on Excel?

How do you put formulas in excel with multiple conditions?

How do you round a number in Excel to an even decimal?

What is the proper link format for MS Excel?

What's the password to format a cell in Microsoft Excel?

Tags:  computer  software

answers

Yes. To do this, select the cell(s) that you would like to apply the formatting to. Then right click and choose, "Format Cells". The option you are looking for is under the number tab. Choose the "Time" subcategory and then choose your favorite option. The hh:mm format is represented as 13:30.

7 votes

right click on Column Name and choose format cells. A window pops up. Choose Number tab and in this taba list for categoires will be displaye. In the list choose Time. Choose Type corresponding to hh:mm

reply
posted by neelesh (31)
5 votes

You can create a special formatting in Excel to create this effect. Go to "Format", Cells, Number tab, "special" and input the format.

5 votes

Report a post on this page as inappropriate
 If you have questions about user content, read our liability disclaimer

  
   
Add your own answer in 50 words or less! Add your comment in 50 words or less!

copyright © 2008
conjecture corporation

FAQ About Us Contact Us Terms & Conditions Privacy Policy