Calculating and adding time
I am trying to figure out how to automatically calculate time differences for a delayed racing start time. I have: a rating which provides a handicap correction factor: PHRF Tod A Sec/ Mile correction number A Total correction in Seconds (based on a distance) This I figured out. I have a set start time for the first entry at 11:00:00 I need to figure out the Start time for the delayed boats as shown in the diagram, but I don't know what formulas will do this. This diagram is taken from a pdf document.
Excel - Conditional formatting
Hi all, I am new to this and i am creating or trying to create a bespoke Excel programme (Gant) that i need for work. i wanted to know if some could assist me with making a simple user tool as i need to share with colleagues i just cannot get the document to Make it so anyone can simply change the task cell colour from the standard Excel pallet options Make it so when the task cell colour is selected, the Gant cell changes to the same automatically Be able to edit the text in any tsk cell and automatically save to drop down choices with all its text and colour inputted Within the assigned to column cells, create individual drop down options when in the cell itself as apposed to t the top line probably easy for some of you that are well versed in Excel formatting and Data validation but certainly not me any help would be appreciated thanks in advance Mike mailto:email address removed for privacy reasons
#Connect Error in Excel for StockHistory Function
Evening, I am an O365 subscriber and am trying to set up an Excel sheet as a VAR template, and I wanted to populate my workbook with some historical data without uploading a CSV. Figured I would try out the StockHistory function. I keep getting "#connect" for my cells, and I am not sure why. I am not in developer mode, do not have any crazy add-ins, I am signed in, and connected to the internet. Do I need to be connected to a source? I am fairly new to learning about the StockHistory Function. Any thoughts on the matter are welcome. I tried all that I could from this site below: https://support.microsoft.com/en-us/office/how-to-correct-a-connect-error-584f7de9-b238-480c-8e8f-de0ba2c1aac9
