CODEWITHSUNDEEP
exceltime
user2207232
user2207232

Reputation: 1

Excel Time calculation based on just one column?

I have an excel sheet having time Column. I want to calculate the total time. The excel column look like this:

Time:

2:14:53 , 2:15:53 , 2:16:53 , 2:19:53 , 2:29:53 , 2:41:53 , 2:59:53

Now I want to calculate the total time without adding any extra column or whatever ?

Upvotes: 0

Views: 965

Answers (1)

Peter Albert
Peter Albert

Reputation: 17475

If the times are time stamps and you're only interested in the delta between the first and the last entry, simply use =A7-A1 - this will return the delta. In case it span across multiple days and you're only interested in the delta "on the watch", use =MOD(A7-A1,1). Note that sometimes the result might be displayed as a normal numeric value (in this example 0.03125instead of 0:45:00). In this case, simply change the format to Time.

In case you're talking about lap times and you want to sum them up, you can simply do this with a SUM formula: =SUM(A1:A7) will return you the total time.

Here's your example: enter image description here

Upvotes: 2

Related Questions