Adding hours

  • Thread starter Thread starter Marcel Nihon
  • Start date Start date
M

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
 
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
|
 
| How can I do to add the hours 13:10 + 14:00
| to obtain 27:10
| instead of 03:10 ?

Niek said:
Hi Marcel,

Format the result cell as Custom, [hh]:mm
Click to expand...
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,
 
Do as Niek said, format the result as [hh]:mm


--
Regards,

Peo Sjoblom


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

Niek said:
Hi Marcel,

Format the result cell as Custom, [hh]:mm
Click to expand...
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,
Click to expand...
 
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,
|
 
Back
Top