add time

  1. 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)...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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 ...
  8. 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...

Some videos you may like

This Week's Hot Topics

Top