+ Reply to Thread
Results 1 to 5 of 5

Night hours calculating

  1. 03-24-2022, 09:36 AM #1
    perobaja
    perobaja is offline
    Registered User
    Join Date
    03-28-2020
    Location
    Bosnia and Herzegovina
    MS-Off Ver
    2016
    Posts
    10

    Night hours calculating

    Hi everyone. I have formula for calculating night hours that have mistake that I can't solve. Can you please help me with it?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-24-2022, 10:11 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,610

    Re: Night hours calculating

    Hi
    is this some kind of homework?
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  3. 03-24-2022, 11:51 AM #3
    perobaja
    perobaja is offline
    Registered User
    Join Date
    03-28-2020
    Location
    Bosnia and Herzegovina
    MS-Off Ver
    2016
    Posts
    10

    Re: Night hours calculating

    Not at all. For you it seems easy but for me is not. I can't find where I am making mistake.
    Reply With QuoteRegister To Reply
  4. 03-24-2022, 11:54 AM #4
    perobaja
    perobaja is offline
    Registered User
    Join Date
    03-28-2020
    Location
    Bosnia and Herzegovina
    MS-Off Ver
    2016
    Posts
    10

    Re: Night hours calculating

    I am 53. Too old for homework.
    Reply With QuoteRegister To Reply
  5. 03-27-2022, 04:36 PM #5
    JeteMc
    JeteMc is online now
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,918

    Re: Night hours calculating

    I assume that the formula in question is in cell J10, however without know what value should be displayed in cell J10, and why, it is hard to help.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    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. [SOLVED] HOURS whats the difference of DAY hours & NIGHT hours per SHIFT formula
    By StephanRS in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-06-2021, 02:35 PM
  2. Seperate simple hours, holiday hours and night hours
    By enitron in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-27-2014, 07:22 AM
  3. Excel Formula for determining overtime hours, night diff.-OT hours, night diff. hours
    By hdsf in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-18-2014, 07:26 AM
  4. Calculating Day Rate and Night Rate Hours on a Timesheet
    By Hahnium in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-21-2013, 08:18 AM
  5. Calculate night shift hours worked - working hours span the night shift start and end
    By Gratch in forum Excel General
    Replies: 4
    Last Post: 09-21-2012, 12:58 AM
  6. Calculating Regular Hours, Over Time, Regular Over Time Night Differential, Night Differen
    By trickstah86 in forum Excel General
    Replies: 2
    Last Post: 07-27-2012, 04:54 AM
  7. finding night hours (0-day,1-night) between ranges of data
    By sensation in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-09-2012, 09:08 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