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.

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"

I have used the duration function, entering 24 hours. I am entering my time as 00:00.

I have looked for a template on the web that has a similar layout, but they all display the time as 0h0m.

Please help!

Thank you