 |
 |
| About MrExcel |
| Consulting Services |
| Learn Excel Resources |
| Challenge of the Month |
| MrExcel Seminars |
| MrExcel Store |
| Podcast |
| Search |
| Contact |
| Home |
 |
Past Tip of the Day
|
|
Rob asks "I have programed a cell to round the time to the nearest quarter hour. Such as, 8 hours 14 minutes would show as 8:15:00. Now I want to program the cell to show that 8:15:00 as 8.25. What is the formula for that?" If you have 8:15:00 in A1, use this formula (And format as General, or as Number with 2 decimals) =A1*24
MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.
|