+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Formula help... Time calculation

Hybrid View

  1. #1
    Registered User
    Join Date
    10-21-2011
    Location
    Texas
    MS-Off Ver
    MS Office 2003/2007/2010
    Posts
    1

    Formula help... Time calculation

    I'm trying to create an excel file that will calculate my time. I have most of it figured out already, but I need a little help on the last part. Working full-time at my company, I have to be clocked in for at least 40 hours a week. My boss doesn't want us to work over time, so sometimes I have to leave early on Fridays to prevent going over. The spreadsheet I've created adds the sum of hours worked per day, deducts it from 40, and shows me how many hours I have left to work for that week. What I'm trying to get my spreadsheet to do now, is to tell me exactly what time I will need to clock out based on the number of hours I need to work on a particular day. For example, if I enter that I clocked in at 8:15 AM, and that I need to work 6 hours, what formula will I use in order to see that I need to clock out at 2:15 PM? What about if I wanted to include a lunch in that?

    I've attached what I have so far. The part in the yellow is what I'm needing help with. My company rounds time to the quarter-hour, that's why there are two "Time Calculators"... One is the actual time, the other is the rounded time.

    If you need anything explained, just let me know...
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor khamilton's Avatar
    Join Date
    10-08-2009
    Location
    IL
    MS-Off Ver
    Excel 2007
    Posts
    345

    Re: Formula help... Time calculation

    Hours you need to work yet divided by 24. Then add that to your in time. HTH
    Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

  3. #3
    Forum Contributor
    Join Date
    05-14-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2007
    Posts
    187

    Re: Formula help... Time calculation

    hi

    please find attached my time sheet which i use and see if it is useful

    regards,

    veejar
    Attached Files Attached Files
    Last edited by arthurbr; 10-21-2011 at 02:21 PM. Reason: Remove unnecessary quote

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1