How do i change the result of a formula to normal text or values [Solved/Closed]

Report
Posts
23
Registration date
Thursday January 23, 2014
Status
Member
Last seen
October 10, 2014
-
Posts
23
Registration date
Thursday January 23, 2014
Status
Member
Last seen
October 10, 2014
-
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 ?

thank you in advance ,
Regards

3 replies

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
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2669
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2020
446
A lot of steps for the same result.
Following your routine on your original values, the answer is still 40.75.

8:00	480	8
8:00 480 8
8:00 480 8
7:55 475 7,916666667
8:50 530 8,833333333

40,75

Is your query solved now?
Posts
23
Registration date
Thursday January 23, 2014
Status
Member
Last seen
October 10, 2014

yea
Posts
2669
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2020
446
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
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
Posts
2669
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2020
446
The answer 16 is wrong.
What should the answer be?, 40 right?
yea exactly 40.05 ...
Posts
2669
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2020
446
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?