Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Shruti Sharma   on Feb 07 In MS Office Category.

  
Question Answered By: Shruti Sharma   on Feb 07

Format the column that contains the times as a "time"
To do this right-click on the column and select format cells..
Then under the Number Tab Select time from the Category List box

Now all you have to do is sum the column in the cell you want the total
i.e.: =SUM(C2:C10) would be placed in C11 if your times were entered in
the C column

Share: 

 
 
Didn't find what you were looking for? Find more on EXCEL Question Or get search suggestion and latest updates.


Tagged: