Originally Posted by
MetoPower
Easy:
Enter hours and minutes as 6375:25 (NOT 6,375:25 or any other way)
MP
Sorry, there is a much easier way in EXcel. Why use decimals and all that conversion????
Format cells as custom [h]:mm:ss, then enter the numbers as 6375:10 and 6789:06, or 6789:6, then in the third cell a formula such as =b1-a1 will yield the answer 413:56:00
If the seconds bother you then change the format to [h]:mm