CODEWITHSUNDEEP
excel
Computer_Nerd
Computer_Nerd

Reputation: 102

Totaling Time Records to Accurately Reflect Hours:Minutes:Seconds

I would like to add all of my times to show the summed total time as HH:MM:SS. For some reason I can't get an accurate value but the Excel window does show that it is possible. Can you help me?

Times:
2:18:36
5:53:29
4:50:25
0:00:54
6:37:56
5:33:16
6:01:17
5:03:18
0:01:58
6:25:36
6:15:34
6:35:46
4:28:34
4:58:38
0:05:11
7:13:04
6:43:08
5:00:08


Sum using [hh]:mm = 9564:18

Sum I want =  84:06:48

Excel Window

Upvotes: 0

Views: 23

Answers (1)

Jan
Jan

Reputation: 421

Greetings: please try format [h]:mm:ss

Upvotes: 1

Related Questions