1. TAPS_MikeDion

    Google Sheets (Excel) - Always highlighted sheet?

    Would anyone happen to know why every time I go to one specific sheet in the Google Sheets/Excel workbook I'm working on, that particular sheet has all of its cells highlighted? I'm guessing it's something simple I'm missing. Every time I go to that one sheet, even if I click a cell to remove...
  2. B

    How to convert Now() to Eastern Standard Time

    Hi, I have multiple users across the US using my application and I utilized the now() function. So is there way to convert all of these now() to eastern standard time because these time stamps are saved in my access database. Thanks
  3. E

    VBA Target.Address for multiple cells

    Hello, I have the below code that works perfectly if you enter/copy data one cell at a time. But I copy/paste multiple cells all the time, at which point the code below gives me an error. Is there a way to adapt the below code to work with multiple cells changing at the same time? Private Sub...
  4. D

    Subtracting times, negative result

    Hi, I'm sure this is quite simple but I'm not getting it. I want to subtract to time values where the result (in this case) will be negative: Time A is entered manually as e.g. 13:30 Time B is a result of a calculation and shows as 16:00 The result should be -2:30?? I've tried different ways but...
  5. S

    Networkdays with start and end times on different days due to multi country shifts

    Hi, I am faced with this scenario where I need to calculate the number of minutes between two date & time stamps with the Start and End time in different hours . My scenario is as below Excluding Hours between 7:00 PM to 11:00 PM EST all other time, excluding Saturday and Sunday and...
  6. W

    Calculating time differences

    I have a Start Time and Stop Time column in my Excel spreadsheet that is feeding the Power BI reports. Time is entered in military time, however I cannot make Power BI Calculate the difference properly when the Start Time is one evening and the Stop Time is the following days morning (i.e...
  7. B

    Transfer Data from 1 sheet to another given conditions.

    Sheet 1 and 2 are a Timesheet setup in a table. Table1 Sheet1 and Table2 Sheet2. Sheet 1 is the 1st 2 weeks of the pay period, Sheet 2 is the second 2 weeks. Formulas in the Table autofill in case a new row needs to be added based on spit days. What I need to do is copy data from 1 of...
  8. P

    Time calculation run hours per day

    I need help to get a calculation of run hours per day for 3 units, based on generator breaker shut/open times. We currently use an integration over time to count the time for the breakers closed, but this gets messed up when the computer is rebooted or updated. I need to calculate the decimal...
  9. R

    Using the rank function PLEASE HELP!

    Hello All, I have multiple vehicles at work and we make multiple drops during a day. I am currently downloading a days’ worth of information for the entire fleet and would like to rank the individual vehicles by the first job completed and then ascending all by the time it was completed (I...
  10. T

    Maybe a loop?

    Hi everyone, I was wondering if there was a way that i would be able to add up some numbers based on whether or not there was a letter in the cell below the cell i want to include. Currently i have a range of numbers but i need to be able to mark them in some way if they are above or below the...
  11. H

    Time used in-cell bar - today's date compared to due date

    Hi. I have a spreadsheet with the following layout: <tbody> H I J Due date Today 5 15/11/2019 =TODAY()<strike></strike> Progress bar needed 6 24/12/2019 =TODAY()<strike></strike> Progress bar needed <strike></strike> </tbody> <strike></strike> 1. What formula do I need in J5...
  12. C

    VBA - Prioritize, Generate and Fill Numbers with multiple criterias

    This is my first post and was hoping someone could help with my dilemma. I stumbled upon the Solver function in my search but I am not familiar with it and have no idea how to implement it. I will try to be as clear as possible. My client wants my company to use a particular time sheet. I...
  13. C

    Using more than one formula in a cell

    I have the following in which i want to populate a notice using more than one formula, sorry my knowledge does not stretch to more than one formula :( I hope I have explained easy enough as below Any help would be much appreciated. Thank you <tbody> A B C D E F G H I J K L M N O Date...
  14. leopardhawk

    Get External Data (long shot question!)

    This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to by 'Get External Data' every year on January 1 at 00:01 local time? The following URL is currently in use on a worksheet within my workbook...
  15. D

    Min and Max in sequence

    Good day, I have two columns of data, 1st is time and the second are values, The time column is from 4.00am to 4.00am the next day increasing by 1hour intervals, the values increase to a max and then decline in a series of highs and lows. I want to calculate the change in value meaning the...
  16. A

    VBA to go to previous workbook

    Hello, I have little knowledge of VBA and I usually do my macros by recording and cleaning the code slightly. I want to know if I am working with two different workbooks I can move between them with my macro without referring to their names because everytime I use the macro the names of the...
  17. K

    Random Highlight only 1 in the each row

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> I need a VBA, which can highlight 1 character out of 1X2 in the each row so far each time 14 total are selected within the 14</SPAN></SPAN> Example.. <b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px...
  18. A

    working with hh:mm:ss formats and IF statements

    Hello I am trying to write an IF statement using date/time/hh:mm:ss data and would appreciate some help. I have ~ 150,000 rows of data so am keen not to review line by line. I have an extract of data with a date time stamp and I have calculated the difference between two times. eg: I have...
  19. T

    UTC to PST one cell to one cell

    I am having difficulty with converting a cell with UTC time <tbody> 2017-08-11T06:15:19.711Z to PST time </tbody> Using Office Pro Plus 2016 Excel 2016 MSO (16.0.4849.1000) 32 Bit
  20. J

    "Choose" function for the Best Running Time

    Hi, I am storing all of m running times on an excel sheet. I have the distance run in column A (lets say A1:100) and the time in column B (B1:100). In a separate table columns E and F have ranges of distances (0 - 10[in E1 and F1 resp.], 11 to 20 in row 2, 1 to 30 I row 3, etc). What I want is...

Some videos you may like

This Week's Hot Topics