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
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?
A1 09 : 19 : 08 A2 23 : 12 : 07
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
the MARLA total is
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
would give you the 2 characters from the left
would give you the 2 characters at the right
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 email@example.com) - also my apologies for the delay in replying - my daughter was struck with a sickness bug - nothing major, but that took my time.