Cumulative time calculation in Excel 2003

May 22nd, 2012 - 03:12 pm ET by Colin Hayes | Report spam
Hi all

I'm having trouble making my worksheet calculate minutes elapsed.

Presently I have this in A and B , where A is adding cumulatively the
times showing in B :

A B

Mins/Secs Mins/Secs

Total

0.00 2.00
2.00 2.30
4.30 3.00
7.30 3.30
10.60 4.00
14.60 4.30
18.90 5.00
23.90 5.30

Clearly , column A should be round to minutes and seconds and not base
10.

The chart should read like this :

A B

Mins/Secs Mins/Secs

Total

0.00 2.00
2.00 2.30
4.30 3.00
7.30 3.30
11.00 4.00
15.00 4.30
19.30 5.00
24.30 5.30

In column A presently I'm using

¤+B4

in the first calculation cell and dragging down to make the calculation.

Can someone suggest an alternative formula to have it work out
accumulated minutes and seconds correctly , please?

thanks.
email Follow the discussionReplies 3 repliesReplies Make a reply

Replies

#1 Spencer101
May 22nd, 2012 - 05:55 pm ET | Report spam
Colin Hayes;1602025 Wrote:
Hi all

I'm having trouble making my worksheet calculate minutes elapsed.

Presently I have this in A and B , where A is adding cumulatively the
times showing in B :

A B

Mins/Secs Mins/Secs

Total

0.00 2.00
2.00 2.30
4.30 3.00
7.30 3.30
10.60 4.00
14.60 4.30
18.90 5.00
23.90 5.30

Clearly , column A should be round to minutes and seconds and not base
10.

The chart should read like this :

A B

Mins/Secs Mins/Secs

Total

0.00 2.00
2.00 2.30
4.30 3.00
7.30 3.30
11.00 4.00
15.00 4.30
19.30 5.00
24.30 5.30

In column A presently I'm using

¤+B4

in the first calculation cell and dragging down to make th
calculation.

Can someone suggest an alternative formula to have it work out
accumulated minutes and seconds correctly , please?

thanks.



Hi,

I think this is more about data entry and formatting than formulas.

There's nothing wrong with the formula you're using, but try enterin
the data as 00:00:00 format (with :'s rather than .'s).

You can format the data to "mm:ss" so as not to show the hours if you s
desire.

Then you need to decide what you want to data to do if/when if loop
past an hour. Will it go back to zero and continue, or just continu
past 60 minutes and carry on meaning it could show 72 minutes rathe
than 1 hour 12 minutes...

Simple to do either way, just depends on what you need.

S


Spencer101

Similar topics