Thread: Create time value from number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tom tom is offline
external usenet poster
  
Posts: 570
Default Create time value from number
I have a column of numbers that I would like to turn into a time value.
Example the number 1520 would be 15:20. I've been thru the functions but
can't find what I want. Can anyone help??

Thanx
Tom
Reply With QuoteReply With Quote