| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding up to nearest quarter, (:25, :50, :75, :00)
I am working on creating a timesheet in excel, I've got most of it figured
out, but now I need to convert my total hours to the nearest quarter(:25, :50, :75, :00). For example: cell K5=7:50 (7 hours + 50 minutes), I believe the nearest quarter hour should be 7:75 or 7.75, how can I get excel to do this. Plus at the end of the week I need to add up all the hours, with minutes converted to nearest quarter. Please help me!!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding to the nearest quarter point? | Excel Discussion (Misc queries) | |||
| Rounding to the nearest quarter (decimal) in a Pivot table | Excel Discussion (Misc queries) | |||
| how do I round 3.30 to the nearest quarter. 3.30=3.25 | Excel Worksheet Functions | |||
| Rounding results to nearest quarter (in decimals) | Excel Discussion (Misc queries) | |||
| Rounding number to the nearest quarter | Excel Worksheet Functions | |||
Threaded Mode
