Ian Bell
asked on
Convert date and time format
Hi,
Can someone please assist with two formulas to convert date and time from a cell with combined date and time
Please refer attached
Thanks
IanConvert time and date.xlsx
Can someone please assist with two formulas to convert date and time from a cell with combined date and time
Please refer attached
Thanks
IanConvert time and date.xlsx
so you want to combine date and time to get a datetime?
ie, D = B+C?
ie, D = B+C?
ASKER
The opposite Neeraj. I want to extract date and time from column D and display as shown in B and C columns.
Thanks
Thanks
try
B13: =TIME(HOUR(D13),MINUTE(D13),SECOND(D13))
C13: =DATE(YEAR(D13), MONTH(D13), DAY(D13))
I copied datetime to D13
B13: =TIME(HOUR(D13),MINUTE(D13),SECOND(D13))
C13: =DATE(YEAR(D13), MONTH(D13), DAY(D13))
I copied datetime to D13
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks guys for those formulas. I chose the one from Neeraj as so simple to satisfy my simple mind :)
You're welcome Ian!
Open in new window