View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Accumulating elapsed time

Format as [hh]:mm

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"ChrisJForeman" wrote in message
...
Can anyone tell me how to accumulate durations in hours and minutes using

the
general workbook? If I use the hmm or hhmm formats or any of the time

formats,
the value rolls over on 24 hours - thus, 25 hours becomes 1 hour - and I

don't
want this.

TIA

Chris