Thread: adding total number of hours in excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers
 
Posts: n/a
Default adding total number of hours in excel?
format cell as [h]:mm

HTH

"Ramy" wrote:

hi
i have a list of hours and want to add teh total in which it has to be
124:10:00
but when using the SUM function it comes as 4:10

i am using hh:mm function

any suggestions please?


Reply With QuoteReply With Quote