Rounding up to nearest quarter, (:25, :50, :75, :00)
hi,
the formula is =ROUND({time}*96,0)/96
as there are 95 quarter hours in a day
Cheers
Darren
"RosaR" 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!!!!!
|