hourly

Hi all I have a DDE-Sample.xls file which I downloaded from the Forex Factory website and found it ran well for me collecting the current selected last prices every second. I would like to modify the data collection rate to 4 hourly or at least less frequently if that were possible. Does...

So I have a report that is emailed to me daily, I have a macro enabled to save the files automatically to a location on my desktop (C:\Users\rwebber\Desktop\TSA Hourly Report) and the file saves as SSC Hourly Update "the date it was emailed". I would like to place a button on my page called...

Hi I have some excel documents that calculate wages for band members depending on certain criteria and band cost. However I want to reverse it so I put in the criteria, enter the band member hourly rate and works out how much the total quote is. It’s difficult trying to explain without showing...

Hi, I am trying to write a formula that will see the source cell data change every day, but in the recipient cells, the information will only be true to what was input on that day. Please see description below: A2 - hourly pay rate. This is the only cell this information will be input...

Hi, Hoping someone can help me. I have a tracker with a list of dates through the year in Column A and in the next 5 Columns the hours are entered for the hours each member of staff works and these are calculated with the hourly rate in the final Column (see below based on one person)...

Hi I currently have a dataset which displays an hourly price each day over multiple years, I then have an index match formula that splits the hourly price into two half hourly prices (same value). Although this works it is taking too long to recalculate each time I update it and has greatly...

Hi All I am trying to create a Excel sheet for a Wage Calculator in Sterling £. This would include my Monthly wage and also working from that what my hourly wage would be. It needs to take in to account overtime worked and different rates and also work out the Total wage after tax. Can...

Hello all, I'm having a bit of a problem, and I'm hoping there's a simple solution. I am trying to enter in Cell B1 an annual pay amount ($28,600), then in C1 place the number of hours worked per week (50), then the next cell D1 should display the hourly pay rate ($10). Iv'e managed to...

Hi friends, I have created a sheet, where I have the following: Module/Project Task Time taken by developer 1 Time taken by developer 2 Time taken by developer 3 Time taken by developer 4 Time taken by developer 5 Developers are segregated by offices, so there are 2 types right now, can be...

Hi, hope some of you gurus can help me please. I have a large download of data from a Gas meter, which I need to analyse to show a line chart with 3 lines: max, min and avg values for each time slot per weekday (M-F) and per weekend day (S-S). Time slots on X axis (horiz) & value of gas used on...

Ok, I have created a fairly large spreadsheet that figures all the work time for employees, including sick time, holiday, vacation, etc. My question is the way I currently have this set up, time is based on a day by day basis, i.e. Mon-Fri, and if someone were to work more than 8 hours, it would...