need corrected data format of date & time like " 04-Jul-2015 23:52:41 020

[arunjyoti.ec]

Hi,

I have data logger which giving date values in this form "04-Jul-2015 23:52:41 020". I want to extract only date & time.

[David A Coop]

Try =VALUE(LEFT(A1,20)), where your date value is in A1. You will need to format the cell, because it will come out as 42189.99492.

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

If several people have responded, when you reply please make it clear WHO you are responding
to by mentioning their name.