+ Reply to Thread
Results 1 to 1 of 1

Change the Time value if it is < 9 hours or >13 hours upon click checkbox

  1. #1
    Registered User
    Join Date
    12-23-2014
    Location
    Japan
    MS-Off Ver
    Office 2010
    Posts
    17

    Change the Time value if it is < 9 hours or >13 hours upon click checkbox

    Hi,

    Being a novice in excel I in need of your help .

    I ve an excel "Time sheet creator "(attached) which extracts the data from a in-out time excel file(not attached) and it outputs a separate excel file like I attached "Timesheet_10_15_2015.xlx".

    Now my problem is I need add a checkbox in "Time sheet creator" if it is checked, then it will output total working hours per day to 9 hours if it the total time per day is <9 hours or >13 hours. Now I am doing this manually if the working hours is <9 hours or >13 hours. And I ve tried something in L351 but seems some error. Any suggestion would be very helpful and save my lot of time in daily basis.

    Best Rgds
    PD
    Attached Files Attached Files
    Last edited by pradyumnajpn10; 10-15-2015 at 02:17 AM.

+ 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. [SOLVED] Timesheet that calcs time in, time out, lunch used, reg hours, ot hours, double hours
    By noobface in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-21-2021, 03:45 AM
  2. Replies: 2
    Last Post: 11-12-2014, 11:56 AM
  3. [SOLVED] Adding hours to start time - Business hours/holidays/weekends
    By Thunderer in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-21-2014, 01:09 PM
  4. [SOLVED] Formula to Calculate Normal Hours, Time & 1/2 & Double Time from Daily Hours per week
    By KazzICC in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-17-2014, 01:51 AM
  5. If time period falls outside of normal working hours how many hours does it add.
    By chrisdromey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-02-2013, 11:56 PM
  6. [SOLVED] converting decimal hours to regular time but longer than 24 hours
    By rkruse in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-21-2013, 07:45 PM
  7. [SOLVED] time:How can I enter a figure for contracted hours which is greater than 24 hours?
    By Chink! in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-13-2005, 02:06 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