View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Örjan Skoglösa Örjan Skoglösa is offline
external usenet poster
 
Posts: 4
Default summing up hours

Hi Chip,

So easy. And so difficult.

Works like a charm.

Thanks a lot.

Örjan


On Wed, 1 Oct 2003 08:54:51 -0500, "Chip Pearson"
wrote:

Orjan,

Use a custom number format of [hh]:mm . The brackets instruct Excel not to
"roll over" the displayed time at 24 hours.