View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Finance Guru Finance Guru is offline
external usenet poster
 
Posts: 83
Default 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.