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 the minute figure from K11?
K7 & K11 = 7.5
TIA
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 the minute figure from K11?
K7 & K11 = 7.5
TIA