|
|
#1
05-13-2011, 10:45 AM
|
|||
|
|||
Converting decimal to hours
Hi all, I need for help! I'm trying to convert a time, currently displayed as decimals (ie. 1905.3), into hours that looks like 266:19:00. When I try to use the [h]:mm:ss custom format, 1905.3 becomes 45727:12:00 for some reason. Please help! Thanks, 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Decimal tabs with space as thousands separator | harry | Word | 1 | 12-22-2023 02:59 PM |
| Help on the formulate hours | meninio | Excel | 2 | 02-11-2011 04:56 AM |
 Excel convert format [h]:mm:ss to decimal
|
gchan2000 | Excel | 1 | 08-17-2010 01:36 PM |
|
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 |
Windows XP 
Office 2007
Threaded Mode