Thread: convert decimal to time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ganga ganga is offline
external usenet poster
  
Posts: 42
Default convert decimal to time
i want to know how to change the decimal to time format.

eg: when i enter the time as 9.30 i want that to be changed as 9:30 and
also when i enter the time as 1.38 to be changed as 13:38

Thnak you
Reply With QuoteReply With Quote