I need to round a time to the nearest quarter hour and have it show in quarters. My formula figures out the hours worked. If the total is 8.36, then it needs to show 8.75. It needs to round up or down to nearest quater hour. How can I do this??
Firstime said:I need to round a time to the nearest quarter hour and have it show in quarters. My formula figures out the hours worked. If the total is 8.36, then it needs to show 8.75. It needs to round up or down to nearest quater hour. How can I do this??
Firstime said:I need to round a time to the nearest quarter hour and have it show in quarters. My formula figures out the hours worked. If the total is 8.36, then it needs to show 8.75. It needs to round up or down to nearest quater hour. How can I do this??
gaynard_nelson said:I understand the 8.36 is hours and minutes...
Mark W. said:gaynard_nelson said:I understand the 8.36 is hours and minutes...
If 8.36 was in the form of h.mm wouldn't the nearest quarter hour be 8.45 rather than 8.75?