Time issue

**Zeezar** · 09-04-2009, 02:00 AM

I have this problem...

I want to add time together, but when the hour is >24 it starts a 0 again.
How do I make a formula that keeps counting hours?

Its use to calculate how many hour a week I work..

fx. I work 37 hours a week (result 37)... The one I have gives 24hours = 0 + 13.... damit...

Regards
Zeezar

**JBeaucaire** · 09-04-2009, 02:03 AM

You have to apply a custom number format to show a total hours greater than 24. The format you want is [h]:mm

**Zeezar** · 09-04-2009, 02:11 AM

Im sorry... Im novice a this... Can u help me even more..

My sheet:
08:00 + 08:00 + 08:00 + 01:00 = 01:00

I want result 25:00

Can u plz tell me want to write
fx. =sum(b51:e51 bla bla bla)

Regards
Zeezar

**JBeaucaire** · 09-04-2009, 02:14 AM

your formula should look like your example, something like:

=A1+B1+C1+D1

After you've entered your formula, click on the cell again.
Press Ctrl-1 to open the Format Cell window.
Click on Number > Category > Custom and type [h]:mm into the Type: line

**Zeezar** · 09-04-2009, 02:30 AM

I send u a picture of the error message I get?

/Zeezar

**JBeaucaire** · 09-04-2009, 10:56 AM

I use Excel 2003. I have multiple sheets setup to add time values that way and using that number format. If you Google search you will find that number format offered as the standard for this need.

I can't speak to why your computer won't accept the standard.