Results 1 to 8 of 8

Need Formula to populate a cell +9 hours

Threaded View

  1. #1
    Registered User
    Join Date
    11-03-2011
    Location
    Philadelphia, Pa
    MS-Off Ver
    Excel 2007 & Excel 2010
    Posts
    5

    Need Formula to populate a cell +9 hours

    Very new to excel programming and 1st post here.
    The attached workbook has some examples.
    I have inserted the drop-down time lists to choose Actual Start Time & End Time.
    30 minutes have been deducted for the employee's lunch period, to show Total Hours Worked.
    I need a formula to add 9 hours time to cell H13 from the time in cell E13.
    In our company, if an employee works more than 15 hours continuously the employee is entitiled to a 9 hour rest period.

    example:

     B13                  E13                    G13                       H13
    Actual Start Time    End Time      Total Hours Worked       Change Of Start Time
           7:00 AM          23:30                   16.0                  8:30 AM
    If possible, could the formula populate the word NO in the Change Of Start Time cell, if the criteria (15.1)hours was not achieveed in cell G13?
    example

      B13                   E13                    G13                              H13
    Actual Start Time    End Time      Total Hours Worked       Change Of Start Time
            7:00 AM           22:30                    15.0                NO
    Every 6 minutes is a point.

    Thank You,

    KDL
    Attached Files Attached Files

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