View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default 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