Excel formula required

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Gadgetman

Thread Starter
Joined
Feb 6, 2003
Messages
387
I have a column of times shown in minutes and seconds eg ( 15:25)

I would like to auto sum the total time.

Any suggestions please.
 
Joined
Aug 30, 2003
Messages
2,702
>> I have a column of times shown in minutes and
>> seconds eg ( 15:25)

That's what you think, possibly. First we need to check.

Click on the "15:25" and check the formula bar. If it says

15:25:00

, it's actually 15 hours 25.

Rgds,
Andy
 

Gadgetman

Thread Starter
Joined
Feb 6, 2003
Messages
387
Ah ! Should I type 00:15:25 to read...... 0 hours, 15 minutes 25 seconds
 
Joined
Aug 30, 2003
Messages
2,702
>> Trying is the first step towards failure.

Outstanding! I got the t-shirt for crimbo & am wearing it as we "speak"!

>> Ah ! Should I type 00:15:25 ...

I'm afraid so. If you have a load of duff values already, you'll need to correct them. Enter 60 in a free cell & copy it. Select the duff values then Edit -- Paste Special -- Divide.

Rgds,
Andy
 
Joined
Aug 30, 2003
Messages
2,702
(Sorry, in a hurry)

That operation should convert your values to decimals, e.g. 15:25 goes to something like 0.010706.

Just select these, then Format -- Cells -- Number -- Time. Use something like 37:30:55. Once you have those, just sum with e.g.

=SUM(A1:A10)

Rgds,
Andy
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top