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.
Is it possible to do this?
Hey all! I currently use Smartsheet to track my trainees' progress and I love the way I can use Conditional Formatting in that program. Unfortunately, my company is going away from using Smartsheet, so I need to move all the information I have to an Excel document. I'm struggling with getting the Conditional Formatting to work the same way I have it in Smartsheet and I'm curious if it's even possible. Here is an image of the Template I will be using for each employee. My plan is to have a tab for each employee, just duplicating the template and renaming it to their name and adding their information. Here are the two things I'm struggling with getting set-up with Conditional Formatting: 1. In the Lvl column, I have a drop down that is linked to the Data tab where the icons on the left are images. I want to be able to select the "Assigned" option and have the A icon show up (this is currently set up) and then have the fill of the box turn to red. I'm struggling to get that to work properly. Currently, when I select the "Assigned" option in the drop-down menu, it just shows the "A" icon. 2. I also want to be able to have the "Date Completed" column change to a specific color if one of the checkbox columns (G, H, I, J, K) are checked (i.e. if G is checked, it turns a light brown, if H is checked, it's gray, if I is checked, then it's red, etc.). This is what it looks like in Smartsheet and how I'm hoping to get it to look in Excel: Thank you!
currency format Excel 360
I highlight a column and click on the format for "currency" and choose options for use 2 decimal places, show dollar sign, then for negative number, no minus sign, no red. Aside from the currency format tab, I choose to format the column in red and bolded using the "home" button. The problem is this format is inconsistently applied. Sometimes it shows a leading minus sign, sometimes it shows a hidden minus sign, and sometimes there is no minus sign at all. This causes me problems when I try to total a column by highlighting it and looking on the lower right for the value. Why is it doing this and how can i stop it?
Excel command icon to change from upper or lower case text
Where is the command icon for changing text from upper or lower case. There is one in word, but none in excel that I can find. I though this would have been a standard feature. After the 40 years of development. Also you can not use, format painter to change the text to upper case either. Please add this feature for the 41st anniversary
Excel Help
Is there a way (either formula or macro /something) for the following. I have 2 different spread sheets (files) open at the same time. First is called Time Card Second is called Wages Time Card will have a staff members details as well as dates and shift times. (20 Tabs for different staff members and their details) Wages will have Tab 1 - Summary of all staff names, hourly rates, hours worked for each day and gross amounts to be paid Tab 2 - 20 payslips with the above mentioned details, but payslip style. Lets call the first person Joe Deer I need something in Time Card next or close, to this person's name, when clicking it it will jump to his payslip in Wages sheet As mentioned. Formula or macro.. Guess anything will do. Thanks
