G
Guest
Hi
I got question for u Pls help me I am tired of this
I have a1 = 8:00 (format cell = [h]:mm), a2 = 9:00 (format cell = [h]:mm) ,
a3 = 9:10 (format cell = [h]:mm)
I have a6 = sum(a1:a3)*24 (format cell = number) - This formula suppose to
add numbers from a1 to a3
The problem is instead of getting 26 hours 10 minutes i am keep getting 26
hours 17 minutes
What can I do to figure out this problem?
If u have sollution pls explain me that and if it is possible can u send me
an e-mail with excel file so i can see how did u do that?
My e-mail adress is (e-mail address removed)
P.s Again I am trying to convert from format time to format number
I got question for u Pls help me I am tired of this
I have a1 = 8:00 (format cell = [h]:mm), a2 = 9:00 (format cell = [h]:mm) ,
a3 = 9:10 (format cell = [h]:mm)
I have a6 = sum(a1:a3)*24 (format cell = number) - This formula suppose to
add numbers from a1 to a3
The problem is instead of getting 26 hours 10 minutes i am keep getting 26
hours 17 minutes
What can I do to figure out this problem?
If u have sollution pls explain me that and if it is possible can u send me
an e-mail with excel file so i can see how did u do that?
My e-mail adress is (e-mail address removed)
P.s Again I am trying to convert from format time to format number