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.