=TIME(LEFT(IF(LEN(P249) = 5, "0" &P249, P249), 2),MID(IF(LEN(P249) = 5, "0" & P249, P249), 3,2),RIGHT(IF(LEN(P249)=5, "0" & P249, P249),2))
This is used to extract a 6 digit number that represents a millitary time HHMMSS (hours, minutes, second)
for example: if the cell says 23 that is means 12:00:23 AM and the statement should return 12:00 AM
if the cell says 172359 that means 5:23:59 and the statement should return 5:23 PM
something here is wrong and I can't figure it out.
ANY GENIUSES OUT THERE?
2007-12-12
04:43:05
·
2 answers
·
asked by
KEYNARDO
5