Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Trying to calculate timecard hours and put OT hours in another cell.

I'm trying to keep a time card that calculates daily hours and weekly hours. For a one week time frame if the hours add up to over forty hours, I want to put the daily regular hours up to 40 hours in one cell and weekly OT hours in another cell. Ex. I work M-F for 45 hours. On Friday I worked 8 hours and it puts 3 hours in regular cell and 5 hours in OT cell.

MacBook Pro (15-inch Early 2011), OS X Yosemite (10.10)

Posted on May 24, 2015 1:47 PM

Reply
2 replies

Trying to calculate timecard hours and put OT hours in another cell.

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