Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 09-02-2012
DMF DMF is offline
Member
 
Join Date: Feb 2012
Posts: 4
Excel 2010 - Timesheet Normal Hours - Help!

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!
Reply With Quote
  #2  
Old 09-02-2012
Member
 
Join Date: Dec 2007
Posts: 2,273
Re: Excel 2010 - Timesheet Normal Hours - Help!

=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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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


All times are GMT +5.5. The time now is 10:00 PM.