Thread: Custom Cell format to mimic time format
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
  
Posts: 99
Default Custom Cell format to mimic time format
Sorry!


=TIME(INT(A1),100*(A1-INT(A1)),0)



Arvi Laanemets


Reply With QuoteReply With Quote