hours and minutes

[h58299]

I have a worksheet in which i input minutes of the hour, what i need is for a cell to show total hours and minutes when the minutes have been added up, i have set it so it divides the total by 60 but it doesn't work out right can anyone help.


[ This Message was edited by: h58299 on 2002-05-18 08:26 ]

[ This Message was edited by: h58299 on 2002-05-18 08:34 ]

[Aladin Akyurek]

On 2002-05-18 08:17, h58299 wrote:
I have a worksheet in which i input minutes of the hour, what i need is for a cell to show total hours and minutes when the minutes have been added up, i have set it so it divides the total by 60 but it doesn't work out right can anyone help.

Custom format he formula cell where you summed them up as;

[h]:mm

I assume the cells with minutes are of proper time format.


[ This Message was edited by: Aladin Akyurek on 2002-05-18 08:23 ]

[h58299]

when i try that the total changes to 10:00 even though the hours add up to 10:25 mins

[Aladin Akyurek]

On 2002-05-18 08:52, h58299 wrote:
when i try that the total changes to 10:00 even though the hours add up to 10:25 mins

Maybe some of the individual entries do not have time as underlying format. Select all of the entries and apply Data|Text to Columns to see whether the sum will change.

[sykes]

hello h58299
I've just had a go, and formatted the cell for:
time, 13:13 i.e. time format and select the first option on the drop down list.
Then in the totals cell (where you want your hours and minutes to be totalled) autosum the range where your minutes are, then divide by 1440. so the totals cell reads:
=SUM(A1:A9)/1440

good luck

Sykes

[sykes]

Blast, it only works if your total minutes comes to less than 24 hrs.

Will have a re-think!

[sykes]

Right. Got it now.
As before (autosum your minutes cells, then divide by 1440) then custom format the totals cell [h]:mm

Let me know if it's ok.

Sykes

[h58299]

works great, thanks you saved my sanity