answersLogoWhite

0


Best Answer

Press Ctrl-1 to open the Format Cells dialog box. Pick the Number tab, then the time, and then Custom and you can change how the time is displayed, like having it show with AM and PM instead of using a 24 hour style. So you can have 3:00PM or 15:00 for example. If you are then doing calculations you can use a custom format to show the hours as a total, to enable it to show above 24 hours, which would be useful for things like time sheets. The following custom format can do that:

[h]:mm:ss

User Avatar

Wiki User

10y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How can you convert time in 24hrs in Microsoft Excel 2010?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the Microsoft version of Excel before 2013 came out?

Microsoft Excel 2010.


How do you play billiards in Excel 2010?

There are no hidden games in Microsoft Excel 2010. The last version that had a hidden game was in Excel 2000. There is a game called Billiards Excel and there are Billiard 2010 games, but these have nothing to do with Microsoft Excel, or any Microsoft software.


What is on Microsoft professional 2010?

Microsoft Word 2010, Power Point, Outlook and Excel.


How can one convert an Excel spreadsheet to an iif file?

One can convert an Excel spreadsheet to an IIF file using the Microsoft Office 2010 software suite. Also one can convert such files using online services like Spreadsheet Converter and Accountant Pro.


Need help using Microsoft Excel 2010?

To do what?


When Microsoft Excel is a new version out?

Excel 2010 is the latest version. A 2012 version is under development.


Is Microsoft Office Excel 2010 compatible with Windows 8?

Yes.


How many rows in Microsoft Excel in 2010?

Up to 1,048,576 rows.


What has the author Mark Dodge written?

Mark Dodge has written: 'Running Microsoft Excel for Windows 95' -- subject(s): Business, Computer programs, Electronic spreadsheets, Microsoft Excel (Computer file) 'Microsoft Excel 2010 inside out' -- subject(s): Microsoft Excel (Computer file), Business, Computer programs 'Running Microsoft Excel 97' -- subject(s): Business, Computer programs, Electronic spreadsheets, Microsoft Excel (Computer file)


How do you convert xlsx to xls?

If you have Excel 2007 or 2010, you can do a Save As to save the file in Excel 2003, which was the last version that used the xls extension. If you do not have those, you can try Open Office or Google Docs or download and install FileFormatConverters.exe from Microsoft Homepage.


What has the author Marco Russo written?

Marco Russo has written: 'Microsoft PowerPivot for Excel 2010' -- subject(s): Business, Microsoft Excel (Computer software), Microsoft Excel (Computer file), Commercial statistics, Computer programs, Computer software


Who invented the new Microsoft Excel 2010?

Ben Bricklin and Bob Frankston