Decimal Time and Rounding

[Joe]

Does anyone know how to convert a regular time to decimal time and then
round it. This is to calculate employee timesheet in decimal time with
a rouding criteria:
0 - 7 minutes = 0 hour
8-22 minutes = 0.25 hour
23-37 minutes = 0.50 hour
38-52 minutes = 0.75 hour
53 + minutes = 1.00 hour.
I can subtract the time sheet and get total hour work for the day and
then multiply it by 24 to get the decimal time, but I can't find a way
to round it in the same formula.
Thanks for your help.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[Frank Kabel]

Hi
try
=ROUND(A1*24*4,0)/4
if A1 stores your time

 

[Joe]

This is great! Thanks, Frank. It's so short, too. I was about to try
if statements or lookup table, but it got to be so convoluted that I got
confused. I still don't understand the reason behind this though, why
multiply by 4 and then divide by 4? Anyway, it works and I am grateful
to you.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **