so for you example what result do you expect? If 3:20 is in A1 then use Charlie's suggestion like this in B1, i.e.
=A1/"4:30"
Format B1 as % and result should be approx 74%, is that right?
so for you example what result do you expect? If 3:20 is in A1 then use Charlie's suggestion like this in B1, i.e.
=A1/"4:30"
Format B1 as % and result should be approx 74%, is that right?
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks