Problem adding time
 

Hello

I have a column with cell format set to time (13:00), but when I tried
to add to get the total number of hours:mins, it gave me wrong sum. I
dont know what is the problem. The target cell's format is also set to
time(13:00).

Any thoughts on this would be appreciated.

Thanks

Kappa

Problem adding time
 

Format Custom as [h]:mm

Or provide more details, like the input values, your formula and the result
you got

--
Kind regards,

Niek Otten

"Kappa" wrote in message
oups.com...
Hello

I have a column with cell format set to time (13:00), but when I tried
to add to get the total number of hours:mins, it gave me wrong sum. I
dont know what is the problem. The target cell's format is also set to
time(13:00).

Any thoughts on this would be appreciated.

Thanks

Kappa