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


Reply With QuoteReply With Quote