Thread: Find unique value in list (TIME), not working
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default Find unique value in list (TIME), not working
I agree with everything Bernd said.
To round a time to the nearest second
you can use this formula:
=MROUND(MyTime,1/24/60/60)

Reply With QuoteReply With Quote