add time

  1. E

    Sum Cells and IF Statement to add times

    I have a table where I record the start time and end time for Frac and Wireline operations on a well, and that process is repeated for each stage of the well. Sometimes we skip stages and no times are entered indicating that skip which messed up the Total Time calculation. I left "Stage 3" (Row...
  2. B

    Subtract Hours from Time Using VBA Change Event

    Hi Community - it's been a while since I did this, and I can't remember for the life of me how to add / subtract hours from time. Here is a draft of the VBA code I have to perform expression: Private Sub Worksheet_Change(ByVal Target As Range) If Target = Range("D6") Then Target.Value =...
  3. A

    Formula for working days

    Hi All I'm hoping someone can help. I'm trying (and failing), to make a formula which adds 2 hours to a column which includes the date and time. Some example dates: 11/11/2015 13:49 12/08/2015 16:36 13/09/2015 07:50 14/10/2015 11:17 The formula has to take account of working days (Mon-Fri)...
  4. A

    Adding Time (minutes) with correct format

    This is my first post and I've read a few other postings about time, but I can't seem to get mine to work. I had the following, which works, but I need to add 15 minutes to the 2nd time (underlined below): If Worksheets("Staffing Comp").Range("D1") = "Friday" Then Sheets("Staffing").Select...
  5. S

    Adding time in two columns

    I download a report from a central server in Excel format which has names and time to show total worked hours. In this report I need to add time in two columns to get the total hours. Here is the example: In the first column the time is given as :18:44 and in the second column :27:04. If I...
  6. S

    DateAdd function in VBA

    Hello to all, I am trying to add five hours to my date and time. I have together the time and date data in a cell in excel format. I want to add five hours at each one of them and I am using the next formula but nothing happens ("H" is the column in which I have the Date and Time) Any help...
  7. B

    Tme

    Hello all, I have a problem which I am sure some of you must have already an answer for me. I need to add times. I have two columns in which I have added times. In one column I calculated the time that for example goes from 10:00 to 13:30, in a second column I have other times expressed in...
  8. S

    Time sheet

    Hi All, I have need to create a time sheet on excel but I'm experiencing some problems. What i need the sheet to do is below:- 1. Have start time / finish time x 2 for each day. 2. Automatically work out hours worked. 3. Should there be less than a 6 hour break between finish time and start...
  9. glowfish

    Add ten minutes to certain entries in timeseries

    Hi I am working with a time series of roughly hourly data. The problem is that some of the times are logged ten minutes before the hour (hh:50) instead of on the hour (hh:00). How do I add ten minutes to only the times that are logged ten minutes before the hour. I guess i should use a if ...
  10. J

    Need help converting long time calculation to UDF

    Hi All, I work with a lot of time based worksheets for a 24/7 operation and constantly use the formula: =IF($E17>$D17,(HOUR($E17)+(MINUTE($E17)/60))-(HOUR($D17)+(MINUTE($D17)/60)),((HOUR($E17)+24)+(MINUTE($E17)/60))-(HOUR($D17)+(MINUTE($D17)/60))) to calculate times worked where $D17 is...

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