ANYONE GOT THE TIME?
Can you please show me the formula.
A1 to A5 contain minutes
e.g 75
105
300
57
111
A10 contains the total amount of minutes
e.g 648 =sum(a1:a5)
Dividing by 60 = 10.80 hrs (10hrs 48mins)
How do I get A10 to display hrs and mins (10.48)
or similar instead of 10.80. To begin with, should
column A be formatted to numbers?
|