=MROUND(A1,1/24/4) and format the cell appropriately. If you get a #NAME!
error, look up MROUND in Excel help.
--
David Biddulph

"SilviaG" wrote in message
...
Is there a way in which when you input a time to round it off to the
nearest
quarter hour?
For example in the excel spreadsheet if i input 8:39 am for the cell to
round it automatically to 8:45 am