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

Thread Tools Search this Thread
Old 09-02-2012
DMF DMF is offline
Join Date: Feb 2012
Posts: 4
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:


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?

Reply With Quote
Old 09-02-2012
Join Date: Dec 2007
Posts: 2,273
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.
Reply With Quote

  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.