# Excel Forumlea

Status
This thread has been Locked and is not open to further replies. The original thread starter may use the Report button to request it be reopened but anyone else with a similar issue should start a New Thread. Watch our Welcome Guide to learn how to use this site.

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.

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;@

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

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

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

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. The original thread starter may use the Report button to request it be reopened but anyone else with a similar issue should start a New Thread. Watch our Welcome Guide to learn how to use this site.

As Seen On

### Welcome to Tech Support Guy!

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

over 807,865 other people just like you!