add time

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

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

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

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

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

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

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

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

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

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