i have number of days in decimal format in column A, i m trying to add it to the datetime of column B to get new date time in column C but simpling adding the decimal to the B value & using different method by converting the decimal to days hrs min seconds n then adding it to B vale to get new date 2...but instead of same result in both column i get different results....m attaching the excel file...plz guide
Which version of Excel are you using? Your profile says 2000.
Which column shows the results you are expecting?
Last edited by AliGW; 05-29-2023 at 07:52 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
column c & d show the new dates using the 2 method
try
in D2
Formula:
=DATE(YEAR(B2),MONTH(B2),DAY(B2)+E2)+TIME(HOUR(B2)+G2,MINUTE(B2)+I2,SECOND(B2)+K2)+IF(HOUR(B2)+G2>24,1)
Last edited by JohnTopley; 05-29-2023 at 01:33 PM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
I asked what the new date should be - which, if either, of the two is what you want and why?Originally Posted by littleangel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks