[The Seven Bays Window Cleaning Company]

Ok Folks... this is doing my nut in !!!!!

I would like to add up all my window cleaning times for each customer on Excel.

Soooo.. I add a column, and input my times in minutes ( 00.30) ect, then autosum the lot.

Ok, then I go into Format, and select the 'time' tab.

I go through all the options, but for the hell of me cannot get the mins to convert to hours & minutes.
It keeps giving me a random time of day - which I don't want.

All I want it to do is add up my mins, and give a value in hours/mins

Any help greatly appreciated[

[Spursboy1972]

Why cant you just put them all in minutes and use the simple formula tab to add them all up. Then you can add another formula below it to divide the total number of minutes by 60. This gives you your hours total. I assume thats what you are after?

I am sure there are probably people out there who will simplify it but seems simple enough to me.

[The Seven Bays Window Cleaning Company]

Yeh, I did that too...

But the the minutes are carried over up to a hundred.

e.g   6.78 mins

I know from that you can see how long it takes, but It would be nice to have it displayed right.... I'm a bloody perfectionist and it drives me crazy sometimes

I'm sure Excel can do it, it just doe's my head in working it out when I'm sure its really simple.

[Ian W]

Hmm, I haven't worked in hours/mins, but are all the relevant cells formatted as hours and minutes? I guess they are, but sometimes it is the little things that are frustrating. :

[The Seven Bays Window Cleaning Company]

yeh, select all the cells, and inputted the data in the right format.... OK, going to have another go now.

[mark dew]

it probably won't do as you want because it works in hours and minutes and not seconds.
You could work the formula yourself as tony suggested but you would end up something like 6.78 seconds.
As you want your answer to read 6.78 minutes it is doing as you want it really.
There is no option on time to have hh/mm/seconds.

sorry i've just reread your post and i'm away with the fairies.
In your formula box where the total is added up you should have for example:
=SUM(A2:A7)/60
You will need to format it in "numbers" and not "time".

and down the bottom of the page you can have a line saying TIME SPENT (HOURS)
and your formula box would say =SUM(A6=A40+A76+A98+A125)

[mark dew]

i've just done a column adding using the above figures with it formatted in time and the result is:

time
35
22
65
41
12
17
04:48:00


very strange. better using the numbers formula and /60

[The Seven Bays Window Cleaning Company]

Glad I'm not the only one .

It's as though you need to change the default calculation setting from ' out of 100' to ' out of 60', then it should be able to calculate in hours, and minutes.

How you do that... I don't know!