+ Reply to Thread
Results 1 to 7 of 7

Total hours worked based on two time entries

  1. 07-29-2011, 07:03 AM #1
    avidcat
    avidcat is offline
    Forum Contributor
    Join Date
    12-15-2005
    MS-Off Ver
    Office 2007
    Posts
    346

    Total hours worked based on two time entries

    In cell B1 I have a starting time and in C1 I have an end time. For cell D1 what formula can I use to calculate the total time worked?

    Sample attached.

    Thanks for any help.

    Nick
    Attached Files Attached Files
    Last edited by avidcat; 07-29-2011 at 08:43 AM.
    Reply With QuoteRegister To Reply
  2. 07-29-2011, 07:31 AM #2
    Azam Ali
    Azam Ali is offline
    Valued Forum Contributor
    Join Date
    05-23-2011
    Location
    Lahore PK
    MS-Off Ver
    Excel 2007, 2013
    Posts
    627

    Re: Total hours worked based on two time entries

    find answer in attatch file
    Attached Files Attached Files
    Azam
    If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
    For prompt answer, be descriptive, concise, short, direct, and to-the-point.
    Reply With QuoteRegister To Reply
  3. 07-29-2011, 07:37 AM #3
    avidcat
    avidcat is offline
    Forum Contributor
    Join Date
    12-15-2005
    MS-Off Ver
    Office 2007
    Posts
    346

    Re: Total hours worked based on two time entries

    Thanks, simple. I was thinking it was more complicated than that.
    Reply With QuoteRegister To Reply
  4. 07-29-2011, 07:42 AM #4
    avidcat
    avidcat is offline
    Forum Contributor
    Join Date
    12-15-2005
    MS-Off Ver
    Office 2007
    Posts
    346

    Re: Total hours worked based on two time entries

    Changing things up a bit. Is it possible as in the example attached. To get a total of hours worked Mon-Sun without having subtotals for each day?

    Basically cell W4 would have total hours scheduled/worked.

    Thanks,
    Nick
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 07-29-2011, 07:56 AM #5
    Azam Ali
    Azam Ali is offline
    Valued Forum Contributor
    Join Date
    05-23-2011
    Location
    Lahore PK
    MS-Off Ver
    Excel 2007, 2013
    Posts
    627

    Re: Total hours worked based on two time entries

    this could be done throgh a helper row as attached
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 07-29-2011, 07:57 AM #6
    daddylonglegs
    daddylonglegs is offline
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Total hours worked based on two time entries

    Try this formula in W4

    =C4+F4+I4+L4+O4+R4+U4-B4-E4-H4-K4-N4-Q4-T4

    custom format that cell as [h]:mm
    Audere est facere
    Reply With QuoteRegister To Reply
  7. 07-29-2011, 08:43 AM #7
    avidcat
    avidcat is offline
    Forum Contributor
    Join Date
    12-15-2005
    MS-Off Ver
    Office 2007
    Posts
    346

    Re: Total hours worked based on two time entries

    thanks for both! really helps me out.

    Nick
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1