Concatenate(?) + Vlookup

Fester675

Board Regular
Joined
Sep 16, 2016
Messages
100
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
 

Forum statistics

Threads
1,077,849
Messages
5,336,734
Members
399,100
Latest member
darcob

Some videos you may like

This Week's Hot Topics

Top