ExcelBanter - How do I convert 5.35 to 5:35 in excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How do I convert 5.35 to 5:35 in excel? (https://www.excelbanter.com/excel-programming/365113-how-do-i-convert-5-35-5-35-excel.html)

elrusty

How do I convert 5.35 to 5:35 in excel?

Can anyone explain how this is done or can it be done?

Ardus Petus

How do I convert 5.35 to 5:35 in excel?

=A1/24
format as time (hh:mm)

HTH
--
AP

"elrusty" a écrit dans le message de
news: ...
Can anyone explain how this is done or can it be done?

Harald Staff

How do I convert 5.35 to 5:35 in excel?

Not quite.
=INT(A1)/24+MOD(A1,1)/14.4

HTH. Best wishes Harald

"Ardus Petus" skrev i melding
...
=A1/24
format as time (hh:mm)

HTH
--
AP

"elrusty" a écrit dans le message de
news: ...
Can anyone explain how this is done or can it be done?

All times are GMT +1. The time now is 05:46 AM.