I have cell (K7) to enter a value for hours
I have cell (K11) to enter a value for minutes
In cell K15, I want the outcome to be HH:MM in decimalised form - 7h:30m = 7.5h
Sheet 2 is where I've linked the Vlookup to for the minute conversion, how can I join together the hour figure from K7 and...
I am trying to setup a dynamic range using offset in name manager which will select every 6th cell in a row starting at E11
i.e. E11, K11, Q11 etc would be selected but only where data is present
Any thoughts please.
MS Excel 2007. Columns G and J are "date" formatted, "dd/mm/yyyy.
In Column K the input is either 1 or 2. For example, if column K11 is "1",
L11 should display the date as in G11. If K11 is "2", L11 should display the
date in J11.
G J K...
Good morning all,
having a mental block today so would be grateful for some direction please.
basically I'm at a loss on how to do this simple thing.
Column K, K20:K173 is where I input data and I'm looking to add a formula in cell K11 that returns a the word "yes" based on the said columns...