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?

ANYONE GOT THE TIME?
 

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

ANYONE GOT THE TIME?
 

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