Another Timesheet Question

S

SilviaG

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
 
D

David Biddulph

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