+ Reply to Thread
Results 1 to 2 of 2

formula to find the difference between time with a conditions

  1. 11-27-2020, 11:53 PM #1
    vhanezta72
    vhanezta72 is offline
    Registered User
    Join Date
    11-27-2020
    Location
    Bandung, Indonesia
    MS-Off Ver
    2016
    Posts
    2

    formula to find the difference between time with a conditions

    I'm trying to make a formula to find the difference between 2 time, and also have a condition like this :

    If work time > 8 hours, then the difference from work time become the overtime
    And here's the image of my table in Excel
    Capture.PNG

    Can you please tell me how to write the formula?
    Reply With QuoteRegister To Reply
  2. 11-28-2020, 12:23 AM #2
    Phuocam
    Phuocam is offline
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,901

    Re: formula to find the difference between time with a conditions

    Work time: = F5 - E5

    Overtime: = MAX(0,G5-8/24)
    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. Formula to find lowest time n 2 groups then the difference between them ignoring “-“
    By Medicguy in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 09-28-2020, 07:25 AM
  2. Need help to find a formula for finding time difference
    By bekwiet in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-13-2019, 01:56 PM
  3. Formula to find the time difference skipping one column
    By mgoutam in forum Excel General
    Replies: 2
    Last Post: 02-09-2016, 08:24 AM
  4. [SOLVED] Need formula to find the difference between time and minus lunch and breaks
    By Shellybelly in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-09-2014, 05:13 PM
  5. [SOLVED] How to find the difference betwwen two rows based on conditions
    By Thinker8 in forum Excel General
    Replies: 11
    Last Post: 11-08-2013, 04:32 AM
  6. Find time difference
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-25-2010, 09:33 AM
  7. Find the Difference between date and time
    By simi in forum Excel General
    Replies: 11
    Last Post: 09-18-2009, 11:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1