elapsed

  1. A

    Need To Get Elapsed Time Between 2 Dates During Working Hours ( All Days Included )

    Hi I need to get the elapsed hours between 2 dates considering that working hours is from 8 AM To 4 PM all days included ( no week ends or holidays ) example : A1 : 11/11/2019 09:31 AM B1 : current time { now() } will be used
  2. M

    Calculating elapsed hours with weekends.

    I'm trying to calculate elapsed time in hours from a start date/time to an end date/time. Work hours are M-F, 6AM - 6PM. Below is the formula I'm using. =(NETWORKDAYS(B3,C3)-1)*("18:00"-"6:00")+MOD(C3,1)-MOD(B3,1) The problem I'm having is if the start day is after business hours or on...
  3. R

    Elapsed Time (h):mm:ss

    Hello, new to the forum with little knowledge of Excel. I've been searching for a formula for elapsed time showing in (h):mm:ss between to date/time Stamps i.e. Start date/time 7/10/2019 10:53 AM and finish date/time 7/10/2019 2:20 PM that will exclude weekends & holidays to no avail. I have the...
  4. K

    Adding time from a list of starts and stops to come up with a single start/stop

    I have start times listed in column A and corresponding stop times in column B I need a macro to calculate all the elapsed time and create a new stop time adding all of the elapsed time together. So if: A1 = 12:00 PM B1 = 1:15 PM A2 = 1:30 PM B2 = 2:15 PM A3 = 10:00 PM B3 = 1:30 AM Total...
  5. A

    Time Elapsed Between Two Dates

    I have this formula for which I am using to determine how much time has elapsed between two dates. dresult = Now - lresult Now = 2019-04-14 7:45:10 PM lresult = 2019-04-13 7:34:26 PM dresult = 1.00744212963036 How must I manipulate dresultto get the number of hours elapsed?
  6. S

    Elapsed Time - working with the data in the field

    Hi. I've created an elapsed time (formatted as [h]) from this formula:-...
  7. T

    Getting Excel to recognize elapsed time instead of time.

    Trying to paste tabular data into Excel from the web. The web table looks like this. <tbody> 1 12:30 12:30 9:14 0.74 0 453 3.6 4.8 22.6 96 115 78.9 63 2 6:10.0 18:40 3:40 0.79 0 413 7.7 12.9 31.9 102 135 77.0 33 3 8:50.0 27:30 8:31 1.40 0 2,034 9.5 9.9 12.2 87 109 75.1 28 4 7:40.0 35:10...
  8. L

    elapsed minutes

    Hi In this thread, Barry said "you can use [h]:mm. the same works for minutes and seconds.." No problem with hours but with minutes, I do not see how it can be elapsed. I tried this code but did not work [h]:[mm] Thanks...
  9. Y

    Average time elapsed in hh:mm format between 2 dates after accounting for weekends and business hours

    Hi I have a ticket resolution data as shown below. I would need this data to monitor my SLA compliance. Excel 2007 32 bit <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>#F0E0E0[/URL] "] A B C D E F </thead><tbody> 2 Ticket Assigned Date Acknowledged...
  10. K

    Searching text string and working out elapsed time

    Hi, I have a little experience of Excel but this is a bit beyond my skills. We are thinking of using Microsoft's StaffHub to do staff rotas but need to generate data for some reports. We can export the data from StaffHub to Excel format but have no control over how the original information is...
  11. J

    How do I subtract dates using one formula if a cell has a date in it but another formula if it is blank

    A1 has 7/22/17 18:50:00 in it A2 has a 7/28/17 22:01:22 in it A3 is where I want results I can use a simple text formula to get the diff here =TEXT(a1-a2," d:h:mm") to get the elapsed days hours and minutes. My problem is when there is no information in A2 (because it is not complete or I do...
  12. K

    calulate time from two different dates and times without non working hours

    I'm trying to calculate the total elapsed time from two different dates and times, however I need to subtract out 2am-5am since no work is going on. Please see example below: A2 Date Start 12/01/13 B2 Time Start 1:00 C2 Date End 12/04/13 D2 Time End 18:00 E2 Time Elapsed (hrs) ??? I know...
  13. K

    time chart for baby

    hi, I'm new to this forum, but was hoping someone can help me convert my baby's feeding data into a chart (a frustrated engineer needing to keep her brain active!). I have a log of start/stop/elapsed times for feeding each day and wanted to see if there is any pattern to it. I could add in left...

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