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...

Some videos you may like

This Week's Hot Topics