I have a formula that I cannot format as text since it's used to calculate SLA. It was previously calculating properly but for some reason will not calculate properly for all cells in the column. I cannot figure out why it's just now calculating wrong.
The formula is Date+Time=DateTime and is formatted as "m/d/yy h:mm;@". Below is an example of the results.
Date Time DateTime Result 08/03/15 0:00 7/28/16 0:00 WRONG 08/14/15 17:06 8/14/15 17:06 Correct
Any help is greatly appreciated.
Last edited by DoodlesMama; 10-15-2015 at 12:01 PM.
The calc worked for me. can you post a sample workbook.
Regards,
amotto
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Please post a file with the erroneous calculation.
I have repeated the calculation (A2+B2) with the data supplied and obtained the correct result in both cases (UK format)
Example file attached.
The erroneous cells are date and time, Delete and format as time (hh:mm)
The reason is because you have an actual date in column C, not just a time, it is adding the date to a date and time
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks