Related:

- How do i change the result of a formula to normal text or values
- The result of a formula in a cell is the * - Forum - Excel
- Excel result sheet grade formula - How-To - Excel
- How to change text color in excel formula ✓ - Forum - Excel
- How to auto change sheet reference in copied formulas - Forum - Excel
- Facebook account hacked email and phone changed ✓ - Forum - Facebook

## 3 replies

kelnasawa

Hello my friend , i came up with a whole new formulas check it out

http://www36.zippyshare.com/v/94144857/file.html

http://www36.zippyshare.com/v/3998311/file.html

http://www36.zippyshare.com/v/19370980/file.html

http://www36.zippyshare.com/v/22006936/file.html

...

in picture number 1 we calculate the time and format it in h:mm ... then in pic number 2 we convert the hours into minutes then in pic number 3 we convert it back into hours with formatting cells with numbers and 0 decimals ...

then in pic number 4 u just select the cells u want to sum and u can see the answer down in the bottom ... or u can simply add the =sum formula

and voila :D

http://www36.zippyshare.com/v/94144857/file.html

http://www36.zippyshare.com/v/3998311/file.html

http://www36.zippyshare.com/v/19370980/file.html

http://www36.zippyshare.com/v/22006936/file.html

...

in picture number 1 we calculate the time and format it in h:mm ... then in pic number 2 we convert the hours into minutes then in pic number 3 we convert it back into hours with formatting cells with numbers and 0 decimals ...

then in pic number 4 u just select the cells u want to sum and u can see the answer down in the bottom ... or u can simply add the =sum formula

and voila :D

TrowaD

- Posts
- 2829
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- November 22, 2021

Hi Kelnasawa,

I think you are having a formatting issue.

Normally when you add hours, 23 is the max, since 24 is a day.

Goto cell properties and change format to [h]:mm or [h] (instead of h:mm or h).

Best regards,

Trowa

I think you are having a formatting issue.

Normally when you add hours, 23 is the max, since 24 is a day.

Goto cell properties and change format to [h]:mm or [h] (instead of h:mm or h).

Best regards,

Trowa

kelnasawa

- Posts
- 23
- Registration date
- Thursday January 23, 2014
- Status
- Member
- Last seen
- October 10, 2014

Hello ,

im sorry maybe i explained wrong ...

https://www63.zippyshare.com/v/13824067/file.html

this is the image of what is actually happening as u can see im tryin to sum the cells D9 to D13 but the answer is 16 which is wrong

the the formula in D9 is =C9+(B9>C9)-B9

thank you

im sorry maybe i explained wrong ...

https://www63.zippyshare.com/v/13824067/file.html

this is the image of what is actually happening as u can see im tryin to sum the cells D9 to D13 but the answer is 16 which is wrong

the the formula in D9 is =C9+(B9>C9)-B9

thank you

TrowaD

- Posts
- 2829
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- November 22, 2021

That's weird: 8:00 + 8:00 + 8:00 + 7:55 + 8:50 = 40:45

But you didn't use ":" but "." as a separator. That would mean you are not looking for hours and minutes but hours and a decimal value of minutes.

45 minutes of 60 = 0.75 which would result in 40.75

What am I missing here, how do you get 40.05?

But you didn't use ":" but "." as a separator. That would mean you are not looking for hours and minutes but hours and a decimal value of minutes.

45 minutes of 60 = 0.75 which would result in 40.75

What am I missing here, how do you get 40.05?

Following your routine on your original values, the answer is still 40.75.

Is your query solved now?