+ Reply to Thread
Results 1 to 6 of 6

help with time

  1. 11-14-2014, 06:45 PM #1
    lulua
    lulua is offline
    Registered User
    Join Date
    10-08-2014
    Location
    iraq
    MS-Off Ver
    2010
    Posts
    42

    help with time

    i need when i enter time in cell a1 less than 09:00
    cell b1 = 09:00
    Reply With QuoteRegister To Reply
  2. 11-14-2014, 06:48 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: help with time

    In B1,

    =max(A1, "9:00")
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 11-14-2014, 06:51 PM #3
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: help with time

    =if(hour(a1)<9,"09:00",a1)
    Reply With QuoteRegister To Reply
  4. 11-14-2014, 07:11 PM #4
    lulua
    lulua is offline
    Registered User
    Join Date
    10-08-2014
    Location
    iraq
    MS-Off Ver
    2010
    Posts
    42

    Re: help with time

    shg Wonderful

    thank u
    Reply With QuoteRegister To Reply
  5. 11-14-2014, 07:13 PM #5
    lulua
    lulua is offline
    Registered User
    Join Date
    10-08-2014
    Location
    iraq
    MS-Off Ver
    2010
    Posts
    42

    Re: help with time

    mehmetcik thank u


    Excellent
    Reply With QuoteRegister To Reply
  6. 11-14-2014, 07:26 PM #6
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: help with time

    You're welcome.
    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)

Similar Threads

  1. How to calculate time worked: Start time, end time, lunch break
    By welchs101 in forum Excel General
    Replies: 7
    Last Post: 04-25-2020, 03:23 AM
  2. [SOLVED] Subtracting hours from a shift start time to show time in other time zones
    By Nancie in forum Excel General
    Replies: 10
    Last Post: 11-08-2014, 04:51 PM
  3. [SOLVED] Time sheet, I need a formula for overtime cell into Time 1/2 and double time cells
    By bev in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-18-2013, 11:31 AM
  4. [SOLVED] How to change time stamp formatting general to time formatt without losing time!?
    By thetalldude in forum Excel General
    Replies: 3
    Last Post: 11-06-2012, 01:37 AM
  5. display end time automatically upon entering start time and time usage
    By stoey in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-19-2008, 06:16 PM

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