Single Cell Formula

[Piper5299X]

I need to enter total minutes in a cell, but I want that cell to display in decimal hours. Example: I enter 360 in cell A5, but I want A5 to display 6.0
Another example: I enter 150 in cell A5, but I want A5 to display 2.5.
I've tried entering =Sum(A5/60) and =Sum(A5)/60 in cell A5.

I'm thinking VBA, but no idea how to do it. I've also tried the convert function, but I receive the #VALUE error.

 

[Piper5299X]

Peter_SSs,

Thank you! That worked!!!!

 

[Peter_SSs]

You're welcome.

 

[Dave Patton]

Date and Time.xlsm
	A	B	C	D	E	F	G	H	I	J	K
2	Date	18-11-20								Alternative
3	Code	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Total	Minutes	Hours
4	Total	8.00							8.00	480	8.00
5	400	15							0.25	15	0.25
17b

Cell Formulas
Range	Formula
B4	B4	=SUM(B5:B12)/60
I4	I4	=SUM(B4:H4)
J4	J4	=SUM(B4:H4)*60
K4	K4	=SUM(K5:K12)
I5	I5	=SUM(B5:H5)/60
J5	J5	=SUM(B5:H5)
K5	K5	=J5/60