Need help with #VALUE! Error

L

Lijo

New member
Joined
Feb 12, 2020
Messages
4
Reaction score
0
Points
0
Excel Version(s)
2013
Hi Friends,

I have attached one sheet. From E38 onward when I try to insert formula, getting error value. Kindly help me in this regard.
 

Attachments

  • 0112.xlsx
    13.4 KB · Views: 15
Welcome to the forum. :)

Please make your thread titles more meaningful in future - I have changed yours for you this time. Everybody who comes here needs help!
 
Thank you Ali. Noted you suggestion. But up to E37 it is working. If the dates are text, is there any solution to correct it?
 
Yes, by ensuring that proper date strings are entered into those cells.
 
Thank you for your reply. Is it possible to change text into strings in the above attached file? Would you please explain how to perform this task?
 
There is no easy way - the Text to Columns feature does not work properly when time is included.

In G2 drag copied down to G99:

=DATE(MID(C2,7,4),LEFT(C2,2),MID(C2,4,2))+TIME(MID(C2,12,2),RIGHT(C2,2),0)

Copy the range G2 to G99.

Select cell C2 - right-click - paste values.

Now delete the temporary data in column G.
 
Thanks a lot dear Ali. It worked. Thank you very much for spending your precious time for me. You are great.
 
You must log in or register to reply here.
Back
Top