# How do I get a sum of time?

1. ## How do I get a sum of time?

I am a cyclist and I used Excel to track my rides.
Column 1-Date
Column 2-miles (which I have no problem with
Column 3-time on the bike
I am looking to to see how I can add up all the time I have spent on the bike
I.E
Ride one 3:20:58
Ride two 2:27:33
So on and so fourth

I have clocked well ver a 100 hours. But when I hit sum I get like 7.19

Does this make any sense???

Phil

2. ## Re: How do I get a sum of time?

Format the result cell as [hh]:mm to allow the hours to exceed 24.

--

HTH

RP
(remove nothere from the email address if mailing direct)

"philbox" <philbox@discussions.microsoft.com> wrote in message
news:7188C27F-F065-4828-8684-31AF6F04236D@microsoft.com...
> I am a cyclist and I used Excel to track my rides.
> Column 1-Date
> Column 2-miles (which I have no problem with
> Column 3-time on the bike
> I am looking to to see how I can add up all the time I have spent on the

bike
> I.E
> Ride one 3:20:58
> Ride two 2:27:33
> So on and so fourth
>
> I have clocked well ver a 100 hours. But when I hit sum I get like 7.19
>
> Does this make any sense???
>
> Phil

3. ## Re: How do I get a sum of time?

hi,Can you help me regarding these matter? This is the problem I want to solve, what's the formula for these kind of problem? I really need this. Thanks in advance

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1