Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
menu search
person
Welcome To Ask or Share your Answers For Others

Categories

here is an example

            if 8.30 is there it should be 8 hours 30 minute
            if 8 hour 20 minutes  then 8.20  

           Please tell whether it is possible ? if yes
           how ?      
See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
631 views
Welcome To Ask or Share your Answers For Others

1 Answer

When people talk about decimal hours, they usually mean 0.1 = 6 minutes.

So, the correct formula to convert 8.3 would be:

8 hours + 3 * 6 minutes = 8:18

To convert 8:20 to decimal it would be:

8 + 20/6 = 8.333333 (probably round to 8.3)


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
...