Thread: Rounding time values up and down
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] google@magneticnorth.ca is offline
external usenet poster
  
Posts: 10
Default Rounding time values up and down
If you multiply by 24 (hours in a day), round it off, then divide by
24, it appears to work.

e.g. =ROUND(A1*24,0)/24

Reply With QuoteReply With Quote