Thread: Rounding off time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
  
Posts: 2,276
Default Rounding off time
Hi,
try

=ROUNDUP(A1*15,0)/15

"RD" wrote:

I have the following data: 7:45:00 AM I would like to round off to 8:00 (in
24 hour format). I thought it would be simple but I can't seem to get it.



Reply With QuoteReply With Quote