software

I am trying to calculate the difference between two times and sum the
differences. For example: in cell b2 I have 10:00 AM, in cell c2 I have 6:00
PM. In cell a1, I use the formula =TEXT(c2-b2,quot;h:mmquot;). In cell a1, it does
display 8.00. However, when I sum this 'a' column, it does not show it. It
is a blank value.

My goal is to sum my weekly work schedule of hours and minutes worked, and
then have a cell times it by my hourly rate.

Anyone good at this one?
--
Thanks for your input,

Benjamin

Don't use the text function! That's taking numbers (which can be added) and
turning them into strings (which cannot). Just use =c2-b2 and format the
result as appropriate. Then sum the column and use the custom number format
[h]:mm for the total.

quot;BenjaminRamalhoquot; wrote:

gt; I am trying to calculate the difference between two times and sum the
gt; differences. For example: in cell b2 I have 10:00 AM, in cell c2 I have 6:00
gt; PM. In cell a1, I use the formula =TEXT(c2-b2,quot;h:mmquot;). In cell a1, it does
gt; display 8.00. However, when I sum this 'a' column, it does not show it. It
gt; is a blank value.
gt;
gt; My goal is to sum my weekly work schedule of hours and minutes worked, and
gt; then have a cell times it by my hourly rate.
gt;
gt; Anyone good at this one?
gt; --
gt; Thanks for your input,
gt;
gt; Benjamin