problem formatting mins to HR:Min:Secs in excel

[neuropsychiatry]

I have a list of times in minutes and want to convert to HR:Min:Secs but none seem to convert correctly. I am using custom format > hr:min:secs, no formula as such. thank you.

here is the list in mins >> converts to.....
[TABLE="width: 200"]
<tbody>[TR]
[TD]99.7885835[/TD]
[TD] >> 18:55:34[/TD]
[/TR]
[TR]
[TD]98.4892897[/TD]
[TD]>> 11:44:35[/TD]
[/TR]
[TR]
[TD]99.0356582[/TD]
[TD]>> 00:51:21[/TD]
[/TR]
[TR]
[TD]99.521531>>[/TD]
[TD]12:31:00[/TD]
[/TR]
</tbody>[/TABLE]


thank you!

 

[gaz_chops]

Try

=TIME(0,INT(A1),60*MOD(A1,1))

[TABLE="width: 174"]
<colgroup><col width="87" span="2" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="width: 87, align: right"]99.7885835[/TD]
[TD="class: xl63, width: 87, align: right"]1:39:47[/TD]
[/TR]
[TR]
[TD="align: right"]98.4892897[/TD]
[TD="class: xl63, align: right"]1:38:29[/TD]
[/TR]
</tbody>[/TABLE]

 

[Gerald Higgins]

Hi, yes I can replicate 99.7885835 converting to 18:55:34.

Are you saying that is NOT what you want ?
In which case what DO you want ?
Do you want 1:39:47 ?
If yes, you'll need to use a formula to divide each of your entries by 1440 (the number of minutes in a day).

Excel is actually reading your data as 99 days and 0.7885835 of a day, which is 18:55:34.

 

[gaz_chops]

Think i needed an extra coffee, missed the simple solution!!

 

[Gerald Higgins]

Simple is not always best