• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Date + days:hours:minutes [SOLVED]

madocar

madocar

Member
Hello everyone,


COuld you help me with this issue?


I have a date, lets say 17.7.2013 and countdown time 57 days 22 hours 13 minutes.

And I want to sum these two cells and want to have the result like 28.9.2013 21:22


Is that even possible?


Thanks in advance
 
Hi Madocar


Unless I am reading your post wrong, adding 57 days to 17 July will give you the 12th of September? What are the hours and minutes in your start date? This is important to get the hours and minutes in your end date calculation.


Yes it is possible and here is my take based on the above data. In A2 put the date;


17/7/2013


In B2put your countdown data


57 days 22 hours 13 minutes


In C2 put the following;


=A2 +MID(B2, 1, FIND("d", B2)-2)+TIME(MID(B2, FIND("s", B2)+2, FIND("h", B2)-FIND("s", B2)-2), MID(B2, FIND("rs", B2)+3, FIND("m", B2)-FIND("rs", B2)-3), 0)


It isolates each instance of the words you have above to extract the numbers. Format Cell C2 as required.


Take care


Smallman
 
Thank you for your help.

I was just curious if it is possible to do that by changing a custom number format and then A2 + B2 = 12.9.2013 9:23
 
Hi Madocar


You are most welcome.


Now if you had your days and hours information in B2 in a different format to the way you described say 57.92 as an example. Yes you could just add the two together (a2 + B2) and format your result as a date and it would also give you the same answer. I would suggest that would be a far simplier method to run with.


Take care


Smallman
 
You must log in or register to reply here.
Back
Top