LinkBack URL
About LinkBacks
Hi essee
Another version:
Formula:
=LEFT(SUBSTITUTE(D2," ",""),FIND("d",D2)-1)+0+TIMEVALUE(MID(SUBSTITUTE(D2," ",""),3,2)&":"&MID(SUBSTITUTE(D2," ",""),6,2))
Hi essee
Another version:
Formula:=LEFT(SUBSTITUTE(D2," ",""),FIND("d",D2)-1)+0+TIMEVALUE(MID(SUBSTITUTE(D2," ",""),3,2)&":"&MID(SUBSTITUTE(D2," ",""),6,2))
Last edited by Kevin UK; 09-17-2012 at 12:27 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks