.... or more likely =ROUND((B1-A1)*96,0) ?

Pete's formula would return 5 for a 1:00 or 1:05 difference, instead of 4
which I would regard as being "to the nearest quarter of an hour".
--
David

"Pete_UK" wrote in message
...
Try this:

=INT((B1-A1)*96)+1

where A1 contains the start time and B1 the finish time in Excel time
format.

Hope this helps.

Pete

On Oct 1, 6:26 pm, Ruthie wrote:
I need to compute the difference between to times to the nearest quarter
of
an hour.

For example, if someone enters 12:30 PM and 1:40 PM, I need to return the
number 5 (because there are 5 - 15 min increments). How do I do this?