Rounding up to nearest quarter, (:25, :50, :75, :00)
JE wrote on Wed, 30 May 2007 14:21:55 -0600:
JM K5: 7:50
JM L5: =ROUND(K5*96,0)/96 === 7:45
JM or
JM L5: =ROUND(K5*96,0)/4 == 7.75
JM In article
JM ,RosaR
JM wrote:
?? 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!!!!!
You might also like to display the result as quarters:
Formatcellsnumberfraction.
James Silverton
Potomac, Maryland
E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not
|