Time Bending Conundrum!

[Neozoic]

Hello Clever People,

I have another query for you that is probably so obvious you'll have me as a fool. Anyway, onto my "problem".

I'd like to create a formula to enable me to convert units of time to hours and minutes. The units of time are blocks of 6 minutes. So 10 blocks = 1 hr (or) 60 mins.

How can I set up the formula so as to type in the blocks and have them show up as hours and minutes e.g. Type in [11] in the 'Number of Blocks' cell and the result is 1 Hour and 6 minutes in the 'Hours and Minutes' cell.

Apologies in advance for this most probably glaringly obvious solution, but I'm just thick!

Thanks

Neozoic

 

[FormR]

Hi, you could try this, note you need to format the cell that contains the formula as time:

Excel 2013/2016
	A	B
1	Blocks	Time
2	11	01:06:00
Sheet30

Cell Formulas
Range	Formula
B2	=(A2*6)/1440

 

[Neozoic]

Thank you so much FormR. I feel even thicker now.

You're a Star

Thanks

Neozoic