Results 1 to 6 of 6

Calculate total engine time (cell R2) when the engine mode is ON

Threaded View

  1. #1
    Registered User
    Join Date
    02-19-2022
    Location
    Quebec
    MS-Off Ver
    MS365
    Posts
    3

    Question Calculate total engine time (cell R2) when the engine mode is ON

    Greetings!

    I cannot figure out how to calculate total engine time using a formula (the value should be 1.5 hours). If you look at the "Logbook" worksheet, you'll see a "Time" and "Engine Mode" column with information. Basically, I have to calculate the total engine time (cell R2) when the engine mode is ON i.e. engine mode is ON at 8:00 until 9:00, and ON again at 10:00 until 10:30.

    Any help on how to approach this would be greatly appreciated!

    Thank you.
    CC
    Attached Files Attached Files
    Last edited by ccfong; 02-19-2022 at 07:46 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 9
    Last Post: 10-16-2020, 04:25 PM
  2. Formula for Timesheet - Double Time, Time Half and normal Hours
    By Tracs13 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-12-2017, 09:40 PM
  3. Replies: 3
    Last Post: 08-12-2017, 01:48 AM
  4. [SOLVED] time sheet help, format TIME and formula based on the actual time entered.
    By bh mng in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-06-2016, 01:10 PM
  5. Replies: 3
    Last Post: 12-19-2013, 06:49 AM
  6. Replies: 5
    Last Post: 04-18-2013, 11:31 AM
  7. Formula for Calculating Paid Time Off for fiscal anniversary date real time
    By 168rockwood in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-07-2012, 04:15 PM

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