+ Reply to Thread
Results 1 to 4 of 4

greater than time if statements on excel google sheets

  1. #1
    Registered User
    Join Date
    10-02-2013
    Location
    Leeds
    MS-Off Ver
    MS 365
    Posts
    23

    greater than time if statements on excel google sheets

    If the time in one column is over 07.30 (7 hours and 30 mins) then I want it to do another calculation. Leaving the remaining minutes over 7hrs 30 mins

    Am I on the right track with something like this

    Please note D6 would be time out and C6 time in

    =if(E6<=TIME(7,5,0)," ","SUM(D6=C6)
    Last edited by AliGW; 01-14-2022 at 06:49 AM. Reason: Thread moved to correct forum section.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: greater than time if statements on excel google sheets

    You have a space between the double-quotes - write this as "" instead of " ".

    Also, you have SUM(D6=C6), which will return either 1 or 0. I think this should be just D6-C6.

    Furthermore, you are comparing E6 with TIME(7,5,0) - should this be TIME(7,30,0), and what is in E6 ??

    It would help if you attached a sample Excel workbook, as detailed in the yellow banner at the top of the screen.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    10-02-2013
    Location
    Leeds
    MS-Off Ver
    MS 365
    Posts
    23

    Re: greater than time if statements on excel google sheets

    Thanks

    I got there in the end with this

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: greater than time if statements on excel google sheets

    If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

    Pete

+ 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. Google Sheets. Can I connect offline data from excel to google sheets?
    By drlemur39 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 11-15-2021, 10:40 AM
  2. Google Sheets: Cell changes color based on current time
    By TimRodriguez in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 04-15-2020, 06:48 AM
  3. Migrate VBA that sets time stamp to Google Sheets
    By marko737 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 8
    Last Post: 12-15-2019, 03:03 PM
  4. Migrate VBA that sets time stamp to Google Sheets
    By marko737 in forum Excel General
    Replies: 6
    Last Post: 12-15-2019, 02:32 AM
  5. [SOLVED] IF statements based on conditional formatting? Google sheets
    By rayted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 09-28-2018, 02:41 PM
  6. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  7. [SOLVED] if statements for charting purposes in google sheets
    By mark-gabb in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-25-2014, 12:29 AM

Tags for this Thread

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