How to convert value in time?

[bhasoriya]

There is figure 245, it means 4 hours and 5 minutes. if i am dividing the 245 with 60 then result is 4.08. But actual i want 4:05. Help me please. Which formula or format can do.


Thanks

 

[Faseeh]

Hi bhasoriya,


you can try:

=TEXT(TIME(245/60,QUOTIENT(245,60),0),"HH:MM")

Faseeh

 

[bhasoriya]

Hello Faseeh,


There is something wrong, the result would be 4:05, It is 4:04..

Would also like to inform you, 245 is contained in one cell and there are too many values i want to convert in time, So it would be good for me if i can indicate the cell in formula.


Thanks Faseeh

 

[Faseeh]

Hi,


off-course you can replace 245 will a cell reference! am i right?

 

[bhasoriya]

Hello Faseeh,


Can you please check the uploaded file. so it can help me exactly.


Thanks Faseeh.

 

[Faseeh]

Hello bhasoriya,


Your post is missing file!!


Faseeh

 

[bhasoriya]

Hello Faseeh,


http://rapidshare.com/files/879239108/Time%20convert.xlsx


Sorry for inconvenient

 

[Faseeh]

Hi bhasoriya,


This file shows this message:

Download permission denied by uploader. (0b67c2f5)

Regards,

 

[Debraj]

"Download permission denied by uploader"

Please Permit..

 

[Nic]

I would do this:

=TEXT(TIME(INT(I5/60),I5-INT(I5/60)*60,0),"HH:MM")

Where I5 is the 245

 

[Haseeb A]

Couldn't download your file, but try to divide by 1440 & format as time,


=245/1440

 

[bhasoriya]

Try the below given link.

http://rapidshare.com/files/879239108/Time%20convert.xlsx

 

[bhasoriya]

Thanks Nic, Haseeb A and Faseeh.

Thanks a lot.. finally i get the answer from Nic & Haseeb A.


Thank you very much.

 

[Faseeh]

@bhasoriya,


How did you get 5:00 for 600?


Faseeh

 

[Debraj]

Hi Bhasoriya..


as Haseeb already did the job.. still for future reference..

Excel also has a great & rare used Formula..


=CONVERT(G5,"mn","day")


Play with it..


Regards,

Deb

 

[bhasoriya]

Thanks Debraj,


Ultimately i get the result what i was expecting.


Thanks to all for excellent help.