neuropsychiatry
New Member
- Joined
- Jan 22, 2019
- Messages
- 5
I have a list of times in minutes and want to convert to HR:Min:Secs but only the 4th in the list converts 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"]
<colgroup><col><col></colgroup><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!
here is the list in mins >> converts to.....
[TABLE="width: 200"]
<colgroup><col><col></colgroup><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!