Excel convert format [h]:mm:ss to decimal

		Microsoft Office Forums > Microsoft Excel > Excel
Excel convert format [h]:mm:ss to decimal

FAQ

Thread Tools

Display Modes

08-16-2010, 12:41 AM

gchan2000

Windows XP Excel convert format [h]:mm:ss to decimal

Office 2007

Novice

Join Date: Aug 2010

Posts: 1

Excel convert format [h]:mm:ss to decimal

Hi expert,

I have a cell e.g I14 in format [h]:mm:ss and it is showing 178:50:34.

I want to convert it so that the number of hour (178) multiply by 10. Which should be equal to 1780.

So, i type a formula in another cell which is :

=HOUR(I14)*10
However, it show 2400:00:00 and the format of this cell is [h]:mm:ss which is not my expected.

Please advice?

Regards
Grace

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help in format or link in excel	handsome1968	Excel	1	05-01-2010 09:20 AM
Format Excel to look like Word	Kilconey	Excel	1	04-30-2010 09:42 AM
Convert hours in decimal	ghostones	Excel	1	12-29-2009 09:17 PM
Merge, Too many Numbers right of the Decimal Point	ohdearme	Mail Merge	0	10-25-2009 05:10 PM
Convert a file from HTML to WORD format weblayout view	gtselvam	Word	0	12-02-2008 03:53 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:24 PM.