Thread: How do I convert 5.35 to 5:35 in excel?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
  
Posts: 1,327
Default 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?




Reply With QuoteReply With Quote