calculating hours

P

patricia

I am trying to write a formula that will calculate the difference between time-in and time-out and will figure to the 1/4 hour. If time is 7:07 it should be 7:00 - 7:08 will be 8:15.I need the formula from start to finish and the format to enter time. Thanks
 
J

JE McGimpsey

one way:

=ROUND((A2-A1)/"00:15",0)*15

which, since XL stores times as fractional days, and there are 96
quarter hours in a day, is equivalent to

=ROUND((A2-A1)*96,0)/96

In both cases, you'll probably have to format the cell as a time.
 
B

Bob Phillips

Hi Patricia,

This does the rounding

=ROUND(A1*24*4,0)/24/4

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

patricia said:
I am trying to write a formula that will calculate the difference between
Click to expand...
time-in and time-out and will figure to the 1/4 hour. If time is 7:07 it
should be 7:00 - 7:08 will be 8:15.I need the formula from start to finish
and the format to enter time. Thanks
 
Top