LinkBack URL
About LinkBacks
B1 and copy down:
----A----- -B-- 1 2h 18m 43s 8323 2 01m 16s 76
=86400 * SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(IF(ISERROR(FIND("h", A1)), "0h ", "") & A1, "h ", ":"), "m ", ":"), "s", "")
B1 and copy down:----A----- -B-- 1 2h 18m 43s 8323 2 01m 16s 76
=86400 * SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(IF(ISERROR(FIND("h", A1)), "0h ", "") & A1, "h ", ":"), "m ", ":"), "s", "")
Entia non sunt multiplicanda sine necessitate
That's awesome!
Thanks a lot!
My bad I forgot to mention that some cells only have seconds, like:
16s
How should I modify your formula? it works great when hours and/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks