The basic formula would be:

=ROUND((end-start)*24/0.25,0)*0.25

If there are multiple start/end times:

=ROUND(SUM(end1-start1,end2-start2)*24/0.25,0)*0.25

Format as General or Number

--
Biff
Microsoft Excel MVP


"JackyP" wrote in message
...
help with time sheet formula
time in/time out/time in/time out/time in/time out
can use as much as 3 ins and outs per day
8:30 am to 12:30 pm and 1:30 pm to 4:30 pm, this should equal 7 hours
worked;
what if a person enters
8:25 am to 12:30 pm and 1:30 pm to 4:30 pm, round to nearest quarter hour
this still should be 7 hours;
or 8:22 am to 12:30 pm and 1:30 pm to 4:30 pm, round to nearst quarter
hour
this should be 7.25, not (15min.)
basicly it needs to round both ways to nearest quarter hour no matter what
time they enter.