Rounding question
Posted by Alan Holle on August 23, 2001 2:17 PM
I am dealing with a timekeeping operation that only uses tenths. I need to change the way excel rounds. For example 12:00 p.m. to 7:09 p.m. is 7 hours and 9 minutes. When I convert this to a decimal, excel rounds to 7.2. I dont want to round to 7.2 until 7 hours and 10 minutes. In other words, I dont want to round up to the next tenth until the fourth minute (e.g., 1.5 should round to 1 and 1.6 should round to 2). Any suggestions?