Trying to extract the HH from a cell containg HH:MM
for example if B1 has 10:19 in, i would like C1 to show 10, or even 10:00 would suffice.
i have tried =LEFT(B1,2) this returns 0.
=LEFT(B1,2) returns 0.4 strangely enough
I guess theres an issue because the cell is formatted as...