# 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
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
Hi, Tammy.

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

#### tad724882

Thread Starter
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
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
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
Can you upload your workbook, or even a piece of it?

#### tad724882

Thread Starter
I attached an example. I need the 36:37:00
number to read as a number vs. time.

#### Attachments

• 35 KB Views: 106

#### Anne Troy

Anne
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.

#### tad724882

Thread Starter
This worked!!!! Thanks Tammy!!!!

#### Anne Troy

Anne
You're welcome, Tammy. Sorry it was so painful. I'm not usually so slow.

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.

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.

over 807,865 other people just like you!