Posted to microsoft.public.excel.programming
|
|
Change Times
Hi Joel
My apologies i've been away for three days, just got back.
That works fine.
Thanks for your posts.
All the best.
Dave
"joel" wrote in message
...
I'm not sure why you are getting an error. Maybe there is a blank
characters at the beginning or end of the string or your data isn't in
cell a1.
I modified the function to handle the case where there are no minutes
=IF(ISERR(FIND("m",A1)),LEFT(A1,LEN(A1)-1),(60*LEFT(A1,FIND("m",A1)-1))+MID(A1,FIND("
",A1)+1,(FIND("s",A1)-FIND(" ",A1))-1))
--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=206223
http://www.thecodecage.com/forumz
|