elapsed date and time

  1. P

    Excel formula to calculate elapse days/hours/mins between two dates

    Hi! can you please help me on how to get the elapse days/hours/mins between two dates/time, excluding holidays and Saturday from 4:01am until Monday 04:59pm ? Work shift: starts : 5:00 pm ends : 04:00 am Thanks in advance :)
  2. C

    Work out elapsed time spent at a location

    I am trying to find out how long (in days) a ship is spending at a specific location by analysing satellite data. This would be easy if the ship gave out consistent data, but due to technical issues it gives out inconsistent signals giving incorrect results. The satellite data also gives time...
    • chakyt
    • Thread
    • elapsed date elapsed date and time multiple columns multiple variables subtotal
    • Replies: 13
    • Forum: Excel Questions
  3. K

    Elapsed Time Minus Holidays

    I would like to calculate the difference in time between two dates. Assuming that my company works 24/7 I would like to calculate the difference between an "IN" date/time and "FINISH" date/time skipping over any days that may be in a list of holidays. So, if in cell A1 I have 9/11/2009 9:23...
  4. K

    Due Date & Time

    I want to be able to calculate a due date two days from an entered date/time. If I input 9/3/2009 3:00 PM into cell F6 I would like cell G6 to display 9/5/2009 3:00 PM. The formula that I am currently using includes a holiday list so if the due date lands on a day within that list it gets pushed...

Watch MrExcel Video

Learn Excel - Slicer For Two Data Sets - Podcast 2198

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top