Your result is not 26 hours and 17 minutes, it's 26.17 hours. This is
exactly what you asked for.

If you want your result in time format (eg hours and minutes), sum a1:a3,
ditch the times 24, and format as [h]:mm

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Sunny" wrote in message
...
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

P.s Again I am trying to convert from format time to format number