Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert figures to Hours and minutes
Hi All,
Using Excel 2007. I have the following data A B C D E F G 45 30 38 75 14 202 3.22 My problem is how to get F which is 202 minutes ( a total of A thro' E ) to convert into G which is 3 hrs 22min ( which I show here only to illustrate what I want to achieve ). It all sounds so simple,but I cannot achieve this. Can some one give me the formula to put in G to achieve the conversion. Many thanks in advance -- Wales - the land of fire breathing dragons and rugby palaying wizards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert total minutes to hours and minutes | Excel Discussion (Misc queries) | |||
Convert Decimal hours and Minutes to minutes please. | Excel Worksheet Functions | |||
How do I convert a number of minutes into hours and minutes? | Excel Worksheet Functions | |||
Convert a number of minutes like 400 into hours and minutes | Excel Worksheet Functions | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions |