add time and convert it to currency

S

Sunny

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 [email protected]

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

Bob Phillips

That is 26.17 hours, which is 26 hours and 10 minutes expressed as decimal
time. If you want 26:10, don't multiply by 24, and format as time.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
F

Fred Smith

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
 
Top