Add multiple cells without changing the original format

[ashwingopal]

Hi All,

Im trying to add multiple cells which has =TEXT(cellvalue, "[h]:mm:ss") formula. I tried =sum(range) but end result is 0. but I can able to add only when I select with individual cells eg: =SUM(cell+cell)

So I used =Value(Text(cellvalue,"[h]:mm:ss")) now format is changed to numbers and able to calculate with =Sum(range).

My point is I want my cells to be in this format=TEXT(cellvalue, "[h]:mm:ss"), and sum with range.

is there any way we can do this? Kindly help me out through this

[#2]

@ashwingopal 

Why not to apply custom format

instead of converting to texts? Sum of texts is always zero.

[#3]

Hi @Sergei Baklan,
The contents in the excel is processed through JavaScript so I'm using =Text formula for formatting. Im trying to find the your suggestion via JavaScript.
Thank you
Ashwin