difference in times

  1. T

    Formula for if time is same, earlier or later?

    QUESTION: Can you help me create a formula that looks at time in two different columns and determines if the time is the same, earlier or later? For perspective, this is to determine difference in closing time this winter compared to this summer. Sample data below. CURRENT FORMULA...
  2. R

    VBA: calculate difference in hh:mm between "now"-"target date", excluding weekends

    Hi, Please assist. I am looking to write a VBA code. I have a column named "target date" in mm/dd/yyyy 12 hour(AM/PM) format. for example 9/29/2015 5:20 pm. I want to calculate the difference in hh:mm between "now"-"target date", excluding weekends. i want the resulting difference in hh:mm...
  3. 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"...
  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. T

    Help Calculating Difference Between Dates But only Counting times within certain hours

    Hello, I need to calculate the hours and minutes we respond to something but only counting the hours and minutes that fall within 08:00 to 17:00 Monday through Friday. Example - if we received a call at 09:00 06/01/11 but did not arrive until 10:00 6/2/11 hour 'covered' hours are only from...
  6. F

    Time difference as a percentage

    Greetings ppls. I need to calculate the difference between a start time/date and a finish time/date, and return the result as a percentage instead of a time value. The end time would be equal to 100% and start time would be equal to 0% The difference is usually always a maximum of 5 days...
  7. J

    How to calculate date and time difference with odd months?

    Hi to all, ok I basically have 5 columns D E F G H Collumns D and F are Start and Finish dates written as (MM/dd/year), and E and G Start and finish times. While H is the result table in which I express the difference in fix hour times I need to calculate the difference of these periods but...
  8. J

    Calculating Difference in times and dates

    Hopefully someone can help me, I have Coumn A Column B Column C Column d 7/15/08 13:00 7/20/08 23:00 I need to calculate the difference time including dates, does anyone know how to calculate this???

Watch MrExcel Video

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