ANYONE GOT THE TIME?

[Mickey Mouse]

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?

 

[Dav]

Times are stored as fractions of a day. A 24hr period=1 So to convert
your answer divide the answer in minutes by 1440 (24hr x 60 minutes).
The Result needs to be formated [h]:mm to display the result in hours
and minutes. You can type this in the custom format box. Not that I
think it will effect you you can not have a negative number of hours or
minutes

Regards

Dav

 

[Mickey Mouse]

Thankyou.