| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can you round numbers to display a specific set of numbers, for e.
I am working on a timesheet, and have a question. Due to a request by a user
to be able to only enter time with a signle keystroke, for example, 8:00, only enter 8. Due to that, I have changed my cell formatting from time to numbers. Now, I need a formula that will round the number to a set of predetermined minutes. Example: If a user enters 8.25 for a time in, we would like a formula to change the number to 8.30. I need the formula to do this for the following entries: 0-14: 0 15-29: 15 30-44:30 45-59: 45 Any ideas, or am I very far off base? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
| In Excel, I want to have all telephone numbers display in the sam. | Excel Worksheet Functions | |||
| How to remove page numbers from the display? | Excel Discussion (Misc queries) | |||
| How do I add a range of numbers to sum a specific total? | Excel Worksheet Functions | |||
| How do I format a cell so that only specific numbers can be enter. | Excel Discussion (Misc queries) | |||
Threaded Mode
