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?

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


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=509267

Thankyou.


"Dav" wrote in message
...

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


--
Dav
------------------------------------------------------------------------
Dav's Profile:
http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=509267