+ Reply to Thread
Results 1 to 2 of 2

Caculate time worked / overtime from one day to the next

  1. #1
    Registered User
    Join Date
    05-07-2016
    Location
    Alabama
    MS-Off Ver
    7
    Posts
    19

    Caculate time worked / overtime from one day to the next

    I need to calculate my overtime. I usually start at the same time (10:15PM) and clock out anywhere between 7AM and as late as 9 AM.
    How do I formulate my cells so that all I have to type in is the start and finish time and get the answer back in hours and minutes?

    I tried to upload an attachment, not sure if it took.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Caculate time worked / overtime from one day to the next

    Format columns D and F h:mm AM/PM
    Format column G h:mm
    Format column H number, 2 decimals

    formula G5
    Please Login or Register  to view this content.
    and drag down
    formula H5
    Please Login or Register  to view this content.
    and drag down


    Kind regards
    Leo
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to formulate an overtime worked
    By gerard_gonzales33 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-24-2016, 05:49 PM
  2. Replies: 3
    Last Post: 01-21-2016, 06:07 PM
  3. Replies: 0
    Last Post: 01-18-2016, 03:55 PM
  4. Calculating Overtime (after 40 hours worked)
    By YolandaJ55 in forum Excel General
    Replies: 4
    Last Post: 04-05-2015, 04:59 PM
  5. [SOLVED] Add an amount to wages if Overtime worked, but show zero if there is no overtime
    By KazzICC in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-14-2014, 01:55 AM
  6. Track weekly overtime worked and available ytd
    By excelorfail in forum Excel General
    Replies: 3
    Last Post: 12-29-2008, 12:23 AM
  7. I need a continuous 30 day calendar to track overtime worked.
    By William in Denver in forum Excel General
    Replies: 1
    Last Post: 03-27-2006, 02:12 AM

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