Adding hours

[Marcel Nihon]

Hi,
How can I do to add the hours 13:10 + 14:00
to obtain 27:10
instead of 03:10 ?
Thanks in advance.

Marcel

 

[Niek Otten]

Hi Marcel,

Format the result cell as Custom, [hh]:mm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
| How can I do to add the hours 13:10 + 14:00
| to obtain 27:10
| instead of 03:10 ?
| Thanks in advance.
|
| Marcel
|

 

[Marcel Nihon]

| How can I do to add the hours 13:10 + 14:00
| to obtain 27:10
| instead of 03:10 ?

Hi Marcel,

Format the result cell as Custom, [hh]:mm

Thanks Niek. But, for the format, I know.
The problem is that the result of 13:10 + 14:00 is 03:10,
the clock hour.
I don't need the clock hour.
I need the sum of these hours considered as the duration of a work.
Marcel,

 

[Peo Sjoblom]

Do as Niek said, format the result as [hh]:mm


--
Regards,

Peo Sjoblom

| How can I do to add the hours 13:10 + 14:00
| to obtain 27:10
| instead of 03:10 ?

Hi Marcel,

Format the result cell as Custom, [hh]:mm

Thanks Niek. But, for the format, I know.
The problem is that the result of 13:10 + 14:00 is 03:10,
the clock hour.
I don't need the clock hour.
I need the sum of these hours considered as the duration of a work.
Marcel,

 

[Niek Otten]

Hi Marcel,

Excel doesn't even know the difference between a point in time and a duration. Both are duration since point zero.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|| How can I do to add the hours 13:10 + 14:00
|| to obtain 27:10
|| instead of 03:10 ?
|
| Niek Otten wrote:
| > Hi Marcel,
| >
| > Format the result cell as Custom, [hh]:mm
| >
| Thanks Niek. But, for the format, I know.
| The problem is that the result of 13:10 + 14:00 is 03:10,
| the clock hour.
| I don't need the clock hour.
| I need the sum of these hours considered as the duration of a work.
| Marcel,
|