Hi I’m working on an hours log excel sheet

I need to have a column where someone can enter 20 (as in 20mins) and it will automatically be divided by 60 and represented as a decimal so that the sheet can then add these up and calculate hourly pay.

Could someone please tell me how to make that happen?

​Hi I’m working on an hours log excel sheet I need to have a column where someone can enter 20 (as in 20mins) and it will automatically be divided by 60 and represented as a decimal so that the sheet can then add these up and calculate hourly pay.Could someone please tell me how to make that happen?  Read More

​