Calculating sum of two given times.

  • Thread starter Lee and Rebecca
  • Start date
L

Lee and Rebecca

Is there a way to calculte the sum of two given times? For example, A1 says
08:00 and B1 says 17:00 then C1 will auto calculate "9". Also, if it can be
done, because my time is always based on quarter hour, will the end result
show a fraction? Example, A1is 07:45, B1 is 17:00, then C1 is 9 1/4.
 
B

BenjieLop

<< Is there a way to calculte the sum of two given times? For example
A1 says
08:00 and B1 says 17:00 then C1 will auto calculate "9".>>

=(B1-A1)*24 and format Cell C1 as *_general_*

<< Also, if it can be done, because my time is always based on quarte
hour, will the end result show a fraction? Example, A1is 07:45, B1 i
17:00, then C1 is 9 1/4.>>

Same formula as above BUT format Cell C1 as *_fraction_.*

I hope this is what you are looking for
 
R

Ron Rosenfeld

Is there a way to calculte the sum of two given times? For example, A1 says
08:00 and B1 says 17:00 then C1 will auto calculate "9". Also, if it can be
done, because my time is always based on quarter hour, will the end result
show a fraction? Example, A1is 07:45, B1 is 17:00, then C1 is 9 1/4.
Click to expand...


SUM of two numbers usually means to ADD them together. From your examples, it
seems as if you want to subtract the earlier time from the later time.

If the time will never overlap midnight, then

=B1-A1

If the time might overlap midnight, then

=B1-A1+(B1<A1)

If the time might be more than 24 hours, then you will have to include dates.

---------------

To show the value as a fraction, (and assuming that you will always be
recording to the nearest quarter hour, so that no rounding is necessary), then
you must multiply the results of your subtraction by 24 and format the cell to
show fractions as 1/4's (Format/Cells/Number/Fraction As Quarters)


--ron
 
Top