G
Guest
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,"h:mm"). 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?
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,"h:mm"). 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?