2 Replies Latest reply: Mar 25, 2014 9:39 AM by stewy1968
stewy1968 Level 1 Level 1 (0 points)

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
  • Gary Scotland Level 6 Level 6 (10,390 points)

    Explain what your trying to do, where are you entering a time value and why?

     

    Keynote is a video based Presentation application, Excel is a spreadsheet application.

  • stewy1968 Level 1 Level 1 (0 points)

    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.Screen Shot 2014-03-25 at 11.28.53 AM.pngProblem solved.