![]() |
|
|
|
#1
|
|||
|
|||
|
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 |
|
|
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 |