Border Terrier
New Member
- Joined
- Aug 31, 2005
- Messages
- 23
You have all been so helpful in the past, so here goes again.
In column A, starting in A4 i have times imported as follows,
155656
102630
092536
Now using the formula =TIME(LEFT(A4,2),MID(A4,3,2),RIGHT(A4,2)) in B4 and pasted down, the result in B4 is 15:56:56 in B5 is 10:26:30, this is fine.
Now the problem is in B6, the zero gets ignored and returns 20:53:36 instead of 09:25:35.
Any help to overcome this is appreciated.
Simon
In column A, starting in A4 i have times imported as follows,
155656
102630
092536
Now using the formula =TIME(LEFT(A4,2),MID(A4,3,2),RIGHT(A4,2)) in B4 and pasted down, the result in B4 is 15:56:56 in B5 is 10:26:30, this is fine.
Now the problem is in B6, the zero gets ignored and returns 20:53:36 instead of 09:25:35.
Any help to overcome this is appreciated.
Simon