Excel 2010 - Timesheet Normal Hours - Help!
Populating a timesheet in excel thats works standard and normal hours from a daily hour i.e. 12 hours worked, 7.2 hours standard anything over is overtime.
Currently using the following formulaes:
STANDARD HOURS =MIN(Sheet1!G13,7.2)
OVERTIME HOURS =MAX(0,Sheet1!G13-7.2)
Overtime seems to work fine, but I am finding that if a cell has no data entered (as they haven't worked that day) the standard hours formula is still returning 7.2
Is there anyway I can have it that if G13 was blank the formula would return 0?
Re: Excel 2010 - Timesheet Normal Hours - Help!
would suffice to compute the lapsed time.
And, you can simply use:
where A2:A10 houses elapsed times wrt to some test.
Education, Career and Job Discussions
|Tags: excel 2010, microsoft excel, timesheet|
|Thread Tools||Search this Thread|
|Similar Threads for: "Excel 2010 - Timesheet Normal Hours - Help!"|
|Thread||Thread Starter||Forum||Replies||Last Post|
|Need template for Drivers Hours Timesheet and Forumula in Excel||Tur^turro||MS Office Support||2||15-02-2012 04:57 PM|
|How to modify 60 Mins of Hours to 100 Minute a hour in Excel||Saudamini||MS Office Support||2||27-01-2012 04:24 PM|
|My Office 2010 Trial version expired before 72 hours||kristtoper||Windows Software||4||19-11-2010 02:47 PM|
|Calculation of business hours in Excel||Jayden||Windows Software||3||29-07-2009 08:15 AM|
|Negative hours message problem in Excel 2003||Damien25||Windows Software||3||04-02-2009 05:07 PM|