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
kelnasawa Posts 20 Registration date Thursday January 23, 2014 Status Member Last seen October 10, 2014 - Feb 26, 2014 at 05:07 AM
Related:
- How do i change the result of a formula to normal text or values
- Result formula in excel marksheet - Guide
- How to change number of best friends on snapchat - Guide
- How to change free fire facebook account to google account - Guide
- Number to words in excel formula - Guide
- How to change language in kmplayer - Guide
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
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
555
Feb 18, 2014 at 11:14 AM
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
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
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
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
555
Feb 20, 2014 at 10:55 AM
Feb 20, 2014 at 10:55 AM
The answer 16 is wrong.
What should the answer be?, 40 right?
What should the answer be?, 40 right?
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 24, 2014 at 10:21 AM
Feb 24, 2014 at 10:21 AM
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?
Feb 25, 2014 at 10:29 AM
Following your routine on your original values, the answer is still 40.75.
Is your query solved now?
Feb 26, 2014 at 05:07 AM