 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / May 2008Minutes to hrs calcultion
I have a form where you enter minutes but the calculation needs to give the result in Hr:min. I've tried A2=180 A3=20=SUM(A2,A3)/60 The result being 3.3 but I need it to show 3hrs 20 min Sounds daft I know! Mark You could try the following: =INT(A2/60)&" Hrs "& (MOD(A2,60))&" mins" this will look at A2 - if it has 200 the formula will translate that to 3 Hrs 20 mins edvwvw >I have a form where you enter minutes but the calculation needs to give the >result in Hr:min. I've tried [quoted text clipped - 3 lines] > >Sounds daft I know! Thanks, Don't suppose you know one that will work in word forms too? Regards Mark > Mark > [quoted text clipped - 15 lines] >> >>Sounds daft I know! Sorted it thanks by splitting your previous! > Thanks, > [quoted text clipped - 22 lines] >>> >>>Sounds daft I know! you can try the following formulae =MID(C3,1,FIND(".",C3)-1)&" Hrs"&" "&+MROUND(60*RIGHT(C3,2)/100,1)&"Mins" provided you are getting the results (=SUM(A2,A3)/60) in cell C3. Thanks.  SignatureDilip Kumar Pandey MBA, BCA, B.Com(Hons.) dilipandey@yahoo.com dilipandey@gmail.com New Delhi, India > I have a form where you enter minutes but the calculation needs to give the > result in Hr:min. I've tried [quoted text clipped - 3 lines] > > Sounds daft I know! Hi Mark, You can also try the following:- =MID(SUM(A2,A3)/60,1,FIND(".",SUM(A2,A3)/60)-1)&" Hrs"&" "&ROUND(60*MID(SUM(A2,A3)/60,FIND(".",SUM(A2,A3)/60),3),0)&" "&"Mins" SignatureDilip Kumar Pandey MBA, BCA, B.Com(Hons.) dilipandey@yahoo.com dilipandey@gmail.com New Delhi, India > you can try the following formulae > [quoted text clipped - 11 lines] > > > > Sounds daft I know! Here is another possibility... =TEXT(TIME(0,A2+A3,0),"[h] ""hrs"" m ""min""") Rick >I have a form where you enter minutes but the calculation needs to give the >result in Hr:min. I've tried [quoted text clipped - 3 lines] > > Sounds daft I know! > Here is another possibility... > > =TEXT(TIME(0,A2+A3,0),"[h] ""hrs"" m ""min""") I guess I should mention that this formula assumes the summation of minutes in A2 and A3 does not exceed 1440 (the number of minutes in a day). Also, because of that, the square brackets are not necessary.... =TEXT(TIME(0,A2+A3,0),"h ""hrs"" m ""mins""") Rick Bonsour® Mark Lewis avec ferveur ;o))) vous nous disiez : > I have a form where you enter minutes but the calculation needs to > give the result in Hr:min. I've tried > A2=180 A3=20=SUM(A2,A3)/60 > > The result being 3.3 but I need it to show 3hrs 20 min =SUM(A2,A3)*"0:1" cell format [h]"hrs "m" min" Signature-- @+ ;o))) Hi Mais I am sure following formula solve your problem 100 %. Please put the formula in cell B1 : =IF(ISERROR(QUOTIENT(SUM(A:A),60)&" hours and "&MOD(SUM(A:A),60)&"mins"),"Invalid Input",QUOTIENT(SUM(A:A),60)&" hours and "&MOD(SUM(A:A),60)&"mins") Let me know how was it. :-) Thanks Pawan Kumar Gurgaon India > Bonsour® Mark Lewis avec ferveur ;o))) vous nous disiez : > [quoted text clipped - 7 lines] > cell format > [h]"hrs "m" min" |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.