most recent 30 from http://appleinquiry.com 2010-09-10T20:26:46Z http://appleinquiry.com/feeds/question/71 http://www.creativecommons.org/licenses/by-nc/2.5/rdf http://appleinquiry.com/questions/71/using-hoursminutes-in-numbers Caryn 2009-12-07T15:25:44Z 2010-09-05T07:22:49Z

<p>I need to create a timesheet that will display my time worked in 00:00 format. I had this all worked out in Excel, and moved it to Numbers, which shows errors.</p> <p>Biggest problem is the cell where the time is added together, for a total time for the week. I get an error, saying that "The formula's arguments can only include one date value"</p> <p>I have used the duration function, entering 24 hours. I am entering my time as 00:00.</p> <p>I have looked for a template on the web that has a similar layout, but they all display the time as 0h0m.</p> <p>Please help!</p> <p>Thank you</p>

http://appleinquiry.com/questions/71/using-hoursminutes-in-numbers/78#78 jaxjason 2009-12-12T20:43:50Z 2009-12-12T20:43:50Z

<p>Using Numbers '09 you can utilize the duration and set it up as below. I just use plain math and Sums to get my total and it works just fine. <br>Let me know if you need some more help,<br> Jason</p> <p>(Turns out I am not allowed to use image tags yet. So heres the link to it: <br> <a href="http://files.me.com/kentjason/73nwq" rel="nofollow">Image Link</a></p>