time difference

  1. J

    Exclude time difference from a date range

    I'm trying to exclude duration of a date range from a set of range that is in another sheet: Table_1 shows total time in seconds a ticket was assigned to someone Table_2 shows the time in seconds when the ticket was put on hold Table_1 ID Start_Date End_Date...
  2. D

    Conditional Format based on time difference

    <tbody> Employee ID Name Start Finish 161 Paul 10/08/2019 23:00:00 11/08/2019 06:00:00 100 Fred 10/08/2019 23:00:00 11/08/2019 06:00:00 224 Jane 11/08/2019 10:00:00 11/08/2019 18:00:00 100 John 11/08/2019 15:00:00 12/08/2019 03:00:00 161 Paul 11/08/2019 16:00:00 12/08/2019 02:00:00...
  3. B

    Difference in time in two cells

    Hello all. I need help finding the difference between two times entered in C19 (start time, formatted to time) and F19 (end time, formatted to time). I need to split the results in two different cells, AI19 (hours) and AL19 (minutes). There red will be a lot times when the users time is...
  4. S

    Time Difference In Days Between Two Times

    Hello All. Please help. I am trying to create a worksheet on an iPhone. With MUCH difficulty. I am a lorry driver and what I need is this... I enter the last date and time I finish work in the appropriate cells of week "1". And I add the date and time I start work the following week after my...
  5. T

    Creating a calculated field in a pivot table for time difference

    Hi, I am getting the wrong results in my pivot table's calculate field. I am trying to have a calculated field which gives me the difference between StartDate and EndDate (a promotion sale period). I would appreciate the help. Here is a link to the excel demo file...
  6. A

    Time difference between start and end date and time

    Hello everyone, Question with how to successfully create a cell that is calculating the time difference between two cells that are using a format of month/day/year hh:mm:ss and identifying the difference solely in a hh:mm:ss format, <tbody> Start of project End of project Time difference...
  7. C

    Calculate difference between two times

    Hello. I have a text string that represents a date and time that an employee has signed in. It is a long text string <tbody> (20170102205400) which represents 8:54:00PM 01/02/2017 I then have another time, punch out time: <tbody> (20170103070200) I tried using the TIMEVALUE formula, and that...
  8. A

    subtracting 1 time from another.

    Hey Guys, I am having trouble subtracting one time from another in Excel in order to get the difference of time. How do i subtract 12:00:00 AM from 5:35 AM to get an answer of 5:35 in the first example? I tried to just do (=e3-d3), but it came up "#Value" Would love to figure this one out...
  9. 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"...
  10. T

    ddd:hh:mm need calculate average days

    I have a system that's exporting the time between the time a specimen is collect to the time the result is received. its showing info such as : <colgroup><col></colgroup><tbody> 000:05:08 000:05:08 000:04:30 000:04:24 000:03:54 000:03:44 000:02:46 </tbody> I need to be able...
  11. P

    unable to convert text to date format using date value

    Hi All I have 2 questions related to dates. 1: Im trying to convert the text Aug 07 2014 08:57 PM into a date format recognized by excel. I tried using the date value function without any success 2: Once I am able to get the date in the right format I need to calculate the time difference ...
  12. M

    Formula Help - Differences between two time values

    <tbody> Name Start Time Old Start Time New Change Within 4 hrs? Jeff 9:30 AM 10:30 AM Yes Walter 10:00 AM 9:30 AM Yes Sam 1:00 PM 8:00 AM NO Theodore 12:00 PM 7:00 AM NO Brandt 2:00 PM 12:00 PM YES </tbody> Hello and thanks in advance for your help. I'm...
  13. Smokeyham

    Calculate Closing Time (Rounded to 1/2 Hour) Based on Sunset Time

    Hello, I am trying to set up a system in Excel 2007 (running under Windows 7) to calculate a facility's closing time based upon "rules" about Sunset time. Using the very helpful information from exceldir I was able to download the Sunset times, and convert them using the formula...
  14. G

    Time Difference in Seconds

    Hi, i have start time in variable 1 and end time in variable 2. if i minus, i am getting some big numbers. i am a newbie to excel macro. So could you help me in this scenario to get output in seconds. Many thanks in advance
  15. B

    Automatic adjustable time formula

    Hello, I am trying to create an agenda for an upcoming conference and as I know there will be numerous changes made to the agenda between now and the conference start, I would like to create a formula that automatically adjusts any changes in the timing of events, rather than enter each change...
  16. B

    Time Calculation Question for Excel

    A1 = 18:20:30 B1 = 130 C1 = ? I have a start time (A1) and duration in seconds (B1) and need a formula for C1 to display the new time if B1 were added to A1. In this case, the end time would be 18:22:40. Help, please.
  17. A

    Calculating time difference in seconds.

    I need to calculate time difference quickly as I monitor a phone call from a specific point in the conversation. I'd like to enter it into a cell as a decimal like .59 (59 second mark) and it might would end at 1.30 (1 min 30 second mark). What formula can I use to get the correct time...
  18. X

    VBA Date Time arithmetic

    Hello, I am struggling with date/time calculation in VBA. 1. Can I add/subtract dates as in the next example: Dim vStart As Date, vEnd As Date, vHours As Date dim vHours1 as integer vStart="20:00" vEnd = "23:00" vHours=vEnd-vStart vHours gives me "03:00:00"...
  19. D

    conditional formatting based on time difference

    I am having trouble creating rules for conditional formating based on the time difference between a static time value in a given cell (time due completion) and the NOW function. I would like to have the format of cells change as the time difference changes. I would like to have cells that are 4...
  20. G

    Advanced: Calculate time that falls within period across midnight

    Hi All, I am creating a timesheet using excel 2003 users enter their shift start/finish time and a break start/finish time. Emplyee's can work night shifts (ie across midnight). There are penalty rates which apply at different times. I need to be able to work out the amount of worked time...

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