Calculating Hours

[Ruthie]

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?

 

[Sean Timmons]

=(End Time - Start time)*96

an hour is 1/24th

So, subtracting a time from another time will provide .041667 for each hour.
You'd multiply by 24 to get 1 for each hour.

Sicne you want by the 15 minute increment, multiply the 24 by 4, getting
96... ta da!

 

[Pete_UK]

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

 

[David Biddulph]

.... 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

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