Thread: add time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default add time

You haven't explained exactly what the problem is but if your times are in
hours/minutes (hh:mm) then ensure the "total" cell is formatted as [h]:mm.
The total should be a simple =SUM(A1:A100).

"jfw-Florida" wrote:

I want to add a column of times in a time sheet. I can get the hours worked
but can't seem to get the column to add totalhours