differences between dates

  1. H

    Minutes Between Given Date and "NOW" Across Multiple Dates

    Hi all, I'm having some trouble working out how to do this; I've searched everywhere but as of yet no results have given the level of detail I require. I need to calculate the difference in hours/minutes/seconds between a given date in the format: "29/06/2015 - 13:57:12" and the "NOW"...
  2. L

    Disable enter parameter value

    I have a query in which I'm converting number date "20150415" to "15-Apr-15" and then find the difference between 2 dates. first and last dates I'm using the following expressions; FLabour is a group by "Min" which is searching a Linked ODBC table. Fdate...
  3. K

    Sum Column Differences between date range

    Dear Great Minds of Excel, I have the following data (Except column D) Column A Column B Column C Column D Column E Column F Column G Date 1 Start Time 1 End Time 2 Difference Start Date End Date Avg Time to Complete 01/01/14 08:00...
  4. E

    Count Number of Certain day between two dates

    Hi, I want to count the number of Wednesdays between 02-Apr-14 & 22-Oct-14. If I have the first date in A1 and the second date in B1, does anyone know if it's possible to do this in a formula? thanks, Eoin
  5. M

    Calculating differences between dates with variable time frames

    Hi Im really stumped. Im trying to calculate the differences between 2 dates with variable hours for each day and round up out of hours times up to the next working time. For example Monday - Friday working hours are 07:00 to 18:00 Saturday working hours are 07:00 to 12:00 If a request...

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
Back
Top