# How do i change the result of a formula to normal text or values

Solved/Closed
kelnasawa Posts 20 Registration date Thursday January 23, 2014 Status Member Last seen October 10, 2014 - Feb 18, 2014 at 07:24 AM
kelnasawa Posts 20 Registration date Thursday January 23, 2014 Status Member Last seen October 10, 2014 - Feb 26, 2014 at 05:07 AM
Hello ,
i have a formula which calculates my working hours for each day " =C9+(B9>C9)-B9 " ... when i try to sum all the hours resulted from that formula it gives me some other numbers ...
can anyone please help ? is there a way to change the result of that formula into text so i can sum it or is there a way to calculate it directly ?

Regards

## 3 responses

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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Feb 25, 2014 at 10:29 AM
A lot of steps for the same result.

`8:00	480	88:00	480	88:00	480	87:55	475	7,9166666678:50	530	8,833333333				40,75`

kelnasawa Posts 20 Registration date Thursday January 23, 2014 Status Member Last seen October 10, 2014
Feb 26, 2014 at 05:07 AM
yea
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Feb 18, 2014 at 11:14 AM
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
kelnasawa Posts 20 Registration date Thursday January 23, 2014 Status Member Last seen October 10, 2014
Feb 19, 2014 at 02:15 AM
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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Feb 20, 2014 at 10:55 AM