how do I convert 2.36 to hours and minutes

how do I convert 2.86 to hours and minutes. Excel uses as a "TEXT" function, I don't see that keynote has that.

thanks

iMac, Mac OS 9.2.x

Posted on Mar 24, 2014 3:28 PM

Reply
2 replies

Mar 25, 2014 9:39 AM in response to Gary Scotland

I am using Keynote as a presentation for a new app. I am using the "Table" to perform functions. In 1 box I have "hours worked" and in another, "total of jobs completed". I get a decimal when I divide the two. 3.96. I need to the 3.96 to show as 3hrs 58 minutes. Not sure if its in this post or not, but I just figured it out by selecting the "cell" you get this box. Select what you want to show. I was getting minutes, hours, seconds and milliseconds.User uploaded fileProblem solved.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

how do I convert 2.36 to hours and minutes

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.