Last Edited By **Krjb Donovan** **Last Updated:** Mar 05, 2014 09:56 PM GMT

QUESTION: Dear Aidan Heritage Hay! I m zulfiqar and need help in

As when we add the time in

for example A1 = 04:23:40 A2 = 02:40:30

A3 = 07:04:10

means 7 hours 4 minutes and 10 seconds

hour is of base 10 minute is of base 60 and second is also base 60

now if kanal is of base 10 marla is of base 20 and sarsai is of base 9 than follow the example, How will we solve it?

kanal:Marla:sarsai

A1 09 : 19 : 08 A2 23 : 12 : 07

A3 33 : 12: 06 How will this correct answer we will get in EXCEL

pLS HELP me I shall be thankful of you for this kindness zulfiqar

ANSWER: Using time as an example doesn't help, asstores time as a decimal fraction - it just gets displayed as time in the format you expect. So you will have to break down the values - the SARSAI total is

=mod(c1+c2,9)

the MARLA total is

=mod(((c1+c2-MOD(c1+c2,9))/9)+b1+b2,20)

Hopefully this gives you a working method that you can extend to the Kanal part - I've assumed that the values are in three cells, otherwise you will also have to use string handling to get the right, left and mid parts of the one cell to manipulate.

---------- FOLLOW-UP ----------

QUESTION: Dear Aidan Heritage Hay! First of all I thank you for copration and tought me in excel, so you are now my real teacher. u say that "otherwise you will also have to use string handling to get the right, left and mid parts of the one cell to manipulate." How can I do this Please tell me I donnot know how can I do it zulfiqar

=left(Yourcell,2)

would give you the 2 characters from the left

=right(Yourcell,2)

would give you the 2 characters at the right

and

=mid(yourcell,4,2)

would give you the 2 characters starting from the fourth character - amend all of these as necessary (cannot see the true structure of your data via this medium, but my email if it helps is aidan.heritage@virgin.net) - also my apologies for the delay in replying - my daughter was struck with a sickness bug - nothing major, but that took my time.

Advertisement

©2021 eLuminary LLC. All rights reserved.