Hi Prasad,
Mathematically 8.93hrs does not mean 8 hrs and 93 Minutes. Its 8 hrs and
0.93*60Mins. You can see it comes to 56 Minutes.
You can go ahead with Idrees solution or use the below formula (a bit
complex):
=TIME(INT(A3/60),MIN(((A3/60)-INT(A3/60))*60),)
Where A3 is the ce
Its very easy u can use following functions (Enter 536 in F-22).
=TIME(0,F22,0)
Regards,
Date: Sun, 9 Aug 2009 10:23:33 +0530
Subject: $$Excel-Macros$$ How to convert number into hrs & min.
From: maocca1...@gmail.com
To: excel-macros@googlegroups.com
Dear All Members,
T
Use the Formula
=INT(A4/60)&"Hr"&" "&(((A4/60)-INT(A4/60))*60)&"min"
replace A4 by the cell refrence in your sheet.
It can be modified further if you need, just drop me a mail
Thanks n Regards
Gaurav Banerjee
2009/8/9 Prasad Gadgil
> *Dear All Members,
>
> *To calculate productivity, I need
=A1/(24*60) then change the format it in Time format
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Prasad Gadgil
Sent: Sunday, August 09, 2009 10:24 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to convert number into hrs &
Hi Prasad,
Divive the value with 1440 or (24*60) and change the cell formate ( go to
custom and make the cell format h:mm ) you will the correct result.
regards,
Idrees
On 8/9/09, Prasad Gadgil wrote:
>
> *Dear All Members,
>
> *To calculate productivity, I need to convert total minutes to ho
