I have two columns. In A, there is date and time, and in B, some numbers.
I want to multiple the numbers of B column with the time of A column.
I used a formula in C column like this:
=text(text(A3,"[hh]:mm:ss")*B3,"[hh]:mm:ss")
Now, I got some values in column C which shows total hours, minutes and second.
Now, i want total hours, minutes and seconds of all values in column C. I have total 155 row data. So, i want to SUM of C3 to C157.
How can I do this as normal sum is not working??
Thanks in Advance.
I want to multiple the numbers of B column with the time of A column.
I used a formula in C column like this:
=text(text(A3,"[hh]:mm:ss")*B3,"[hh]:mm:ss")
Now, I got some values in column C which shows total hours, minutes and second.
Now, i want total hours, minutes and seconds of all values in column C. I have total 155 row data. So, i want to SUM of C3 to C157.
How can I do this as normal sum is not working??
Thanks in Advance.