Hi, Format the 8.1 (At the moment I assume it's "hh;mm") as "general" this will give you the time as a decimal fraction of a day.
Multiply this by 24, Divide this by your 10 hrs then multilpy by 100
Regards Mick![]()
=0.340278*24/10*100 = 81.67%
Hi, Format the 8.1 (At the moment I assume it's "hh;mm") as "general" this will give you the time as a decimal fraction of a day.
Multiply this by 24, Divide this by your 10 hrs then multilpy by 100
Regards Mick![]()
=0.340278*24/10*100 = 81.67%
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks