Excel Forumlea

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.

tad724882

Thread Starter
Joined
Feb 15, 2004
Messages
54
I am trying to add up a 5 rows of time (8:00:00). I need the total number of time converted to a whole number. How do I do this?

Thanks so much,

Tammy
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
Hi, Tammy.

In the cell where you have your SUM formula, you need to format the cell as a number.
 

tad724882

Thread Starter
Joined
Feb 15, 2004
Messages
54
We did that, but the number is not correct. For example; the column is adding times (10:00:00, 08:00:00,04:30:00)...When the cell is formatted to a number, the number adding is way off from the orginal total.
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
Then format the time cells as the one that's got 37:30:55 as the example. The custom format for that format shows as [h]:mm:ss;@
 

tad724882

Thread Starter
Joined
Feb 15, 2004
Messages
54
I tried that, and it didn't work...

For Example;
I am adding up the 3rd column. The total number we need to read as a whole number vs. time. When the cell is formated to a number the results is a number 1. When it fact the number should be much higher.
15:30 23:30 8:00
15:30 23:30 8:00
15:30 23:30 8:00
12:30 23:00 10:30
7:53 10:00 2:07
36:37
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
Sorry... my bad.

Change your formula to =SUM(G4:G8)*24
(you're getting the number of days if you just format as number)

Then format as number, 2 decimals, and you get 36.62.

Sorry. :)
 
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

Top