Results 1 to 2 of 2

Thread: Times crossing into midnight for difference or duration

  1. #1
    Neophyte raffrobb's Avatar
    Join Date
    Jun 2019
    Posts
    2
    Articles
    0
    Excel Version
    365

    Times crossing into midnight for difference or duration



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All

    How do I get the correct time difference when times cross over midnight?
    Do I need to include day and time, or can I just do times.

    is best format 3/2/20 11:45:28 PM minus 3/3/20 12:03:31 AM?

    11:45:28 PM 12:03:31 AM

    Thanks
    Robb
    Attached Files Attached Files

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,401
    Articles
    45
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    I've attached a sample that should get you there although... are you sure your original Excel times are right? One of those records (I've highlighted in yellow) actually crosses 2 days.
    Attached Files Attached Files
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •