You could use this formula
=SUM(MID(A2&"000",FIND({"H","M","S"},A2&"xxHMS")-2,2)/{1,60,3600})/24
You could use this formula
=SUM(MID(A2&"000",FIND({"H","M","S"},A2&"xxHMS")-2,2)/{1,60,3600})/24
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks