Get instant live Excel expert help with Time and Date Functions

I would like to add additional formula to the shift roster in the excel spreadsheet, I'm having problems workout the formula. The roster works on inputed information on the above cells, 4 days on in yellow, and 4 night shifts in grey colour, I would like to add additional cycle to the same formula as followed 4 days on, 4 night shift 4 days off, and then the next cycle would be 5 days on, 5 night shifts with 5 days off. thank you.

I am trying to use a formula that will pick up a hyperlink in my excel spreadsheet only when one of my cells reaches the number 0. I have not been able to figure out how to word the formula. I have the cell that is on a days remaining type formula in cell C6 and the hyperlink is in G19. B1-6 and C1-6 are taken the rest of the worksheet is available except for G19. Can you please tell me how to word the formula?

I have a log that contains information for logistics I need to find a formula that will tell me the total ship days and the average ship days. Just now, because some cells are missing information, some cells state #value! and it wont calculate properly

I am looking to have a table populated with various information. The document has a log at the top and a table at the bottom. I need the bottom table to accurately tell me the total ship days for each shipment that has been shipped (marked with a tick) and also average days for each shipment marked with a tick. for those which are not marked with a tick I would like (N/A) populated In the box until the Shipped box is ticked. If the cell is populated with a 0 it will not give me accurate averages.

In cell B17, calculate the number of delivery days for the order. INsert an IF function that first tests whether the value in cell B16 is equal to an emptry test string (""). If it is, return an empty text string; otherwise, apply a lookup function to retriece the lookup value from the table in the range F5:H8 using ht evalue of cell B16 as the lookup value.

Hello, I need to calculate the total projected/forcasted revenue per room type for all 365 days. Plus other questions. What is this formula?

Convert days into weeks. Exercise it by week and sum the amount.

There is a table at the bottom o the spread sheet in Column BG and row 2329. Column BG to calculate the number of days per country. As you can see just now I have a formula in place that calculates up to row 83, that is because if there is not a value in Colum W in gives me an error, so if I try to get a total it only displays the error. I can implement an IFERROR formula however if I do that it turns the lines without a value to 0, meaning my figures are not correct. Any help would be massively appreciated.

Can you calculate an invoice showing: (example) 2 weeks and 2 days @ £70.00 per week. Answer would be £90.00. But can you in box 1 enter 2 weeks and 2 days and it box 2 enter £70.00 and it automatically calculates?

REPOST FOR EXPERT_161, What the formula that you said was not understand to me. I don't know how to calculate the total absent days?