Thread
:
Converting time :: Excell 2007
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Spiky
external usenet poster
Posts: 622
Converting time :: Excell 2007
Oops, I left an extra mess in that post. Ignore that second formula.
This is the one that should work:
=VALUE(LEFT(A1,SEARCH(":",A1,1)-1))+(VALUE(MID(A1,SEARCH
(":",A1,1)+1,2)/60))
Reply With Quote
Spiky
View Public Profile
Find all posts by Spiky