ceiling rounds up, you want the second formula Bernard gave you

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Lori" wrote in message
...
Hi, in an earlier reply you asked if I really wanted to round 1 min to
.25.
No, I do not, didn't catch that one! So, does the CEILING make it round
up
or down accordingly?
Thanks again, Lori
"JE McGimpsey" wrote:

One way:

Assuming 'In' in Columns A & C, 'Out' in columns B & D:

=CEILING((B1+D1-A1-C1)*24,0.25)

XL stores times as fractional days, so multiplying by 24 produces hours
as integers.


In article ,
Lori wrote:

I am working on a timesheet that adds our time up, but I would like on
the
total sum of each day to change to quarter time. Is that possible?
For
example, an employee enters in at 8:30, out at 12:00, in at 12:30, out
at
5:30, the total for that is 8 hours 30 minutes, it shows 08:30. I want
to
change that total to read 8.5 instead of 30 minutes. Maybe a formula
to
change 01 min thru 15 minutes to .25 and so on. Any help? Thanks.