Timesheet formula with time in and time out

Question

Level 1

0 points

Timesheet formula with time in and time out

Hello,

I am deaf and try my best to explain some clear. I need some help with formula and struggle to correct them such as =IF(((G13−D13)÷TIME(0,60,0))<0,(G13−D13)÷TIME(0,60,0)+24,(G13−D13)÷TIME(0,60,0) ).

If you see "F" and "G" are empty, it is not required to add hour, but can add it anytime.

I learn that formula is not the same function from Microsoft Excel to iWork. How can I solve with it to be corrected? Please help me!

Message was edited by: FigureMan

MacBook Air, OS X El Capitan (10.11.1), null

Posted on Nov 24, 2015 11:25 AM

Reply

Answer 1

Best reply

SGIII

Level 8

35,282 points

Nov 24, 2015 11:41 AM in response to FigureMan

Recommend having a look at the Employee Schedule template at File > New and look in the Business section of the template chooser.

You should be able to adapt that easily to your needs.

SG

Reply