Thread: Filtering Numbers
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
  
Posts: 1,397
Default Filtering Numbers
try
=time(int(data/100),mod(data,100))
and format appropriately

"ZachB" wrote:

That first one worked, thank you so much!

Does anyone know how I can make excel recognize those numbers as times?
Reply With QuoteReply With Quote