View Single Post
  #1   Report Post  
Sunny
 
Posts: n/a
Default add time and convert it to currency

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