Thread: Rounding a sum to the quarter hour.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Susan Susan is offline
external usenet poster
  
Posts: 271
Default Rounding a sum to the quarter hour.
I need to be able to round the sum of a formula to the nearest quarter hour,
such as:

This is my formula
=C4-E4-(D4*G4)
which equals 444.98

I need the quarter hours to view .00, .15, .50, and .75.

Susan

Reply With QuoteReply With Quote