ExcelBanter - Another Timesheet Question

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Another Timesheet Question (https://www.excelbanter.com/excel-worksheet-functions/182145-another-timesheet-question.html)

SilviaG

Another Timesheet Question

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

David Biddulph[_2_]

Another Timesheet Question

=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

All times are GMT +1. The time now is 05:21 PM.