Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rounding to nearest quarter hour?
If we have a column of times we're adding up in a formula like, say,
=sum(C4:C20) and we're dealing with times is there a way to modify that formula so that it rounds the total to the nearest quarter hour? p.s., since the spreadsheet had to take into account "negative" hours in terms of subtracting hours, the spreadsheet is set to the 1904 system. Don't know if that makes any difference to the above. Tx. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding to the nearest quarter hour no longer working | Excel Discussion (Misc queries) | |||
Rounding to the nearest quarter | Excel Worksheet Functions | |||
Rounding up to nearest quarter, (:25, :50, :75, :00) | Excel Discussion (Misc queries) | |||
How do I round time to the nearest quarter of an hour | New Users to Excel | |||
Need to round the time to the nearest quarter hour. Help | Excel Discussion (Misc queries) |