Excel 2010 - Timesheet Normal Hours - Help!

[DMF]

Hi,

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?

Thanks!

[EINSTEIN_007]

=EndTime-StartTime

would suffice to compute the lapsed time.

And, you can simply use:

=AVERAGE(A2:A10)

where A2:A10 houses elapsed times wrt to some test.