Calculate elapsed time with a date table

[milhouselucas]

Hi, folks,

Is it possible calculating an elapsed time with a predefined date table of working hours?

For example: I want know an elapsed time of a process between 01/07/2016 09:00 and 10/07/2016 17:00 using this table:

[TABLE="width: 231"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Start time[/TD]
[TD]End time[/TD]
[/TR]
[TR]
[TD]01/jul[/TD]
[TD]08:00[/TD]
[TD]18:00[/TD]
[/TR]
[TR]
[TD]02/jul[/TD]
[TD]06:00[/TD]
[TD]18:00[/TD]
[/TR]
[TR]
[TD]03/jul[/TD]
[TD]06:00[/TD]
[TD]14:20[/TD]
[/TR]
[TR]
[TD]04/jul[/TD]
[TD]08:00[/TD]
[TD]18:00[/TD]
[/TR]
[TR]
[TD]05/jul[/TD]
[TD]08:00[/TD]
[TD]18:00[/TD]
[/TR]
[TR]
[TD]06/jul[/TD]
[TD]08:00[/TD]
[TD]18:00[/TD]
[/TR]
[TR]
[TD]07/jul[/TD]
[TD]06:00[/TD]
[TD]18:00[/TD]
[/TR]
[TR]
[TD]08/jul[/TD]
[TD]08:00[/TD]
[TD]18:00[/TD]
[/TR]
[TR]
[TD]09/jul[/TD]
[TD]06:00[/TD]
[TD]14:20[/TD]
[/TR]
[TR]
[TD]10/jul[/TD]
[TD]06:00[/TD]
[TD]14:20[/TD]
[/TR]
</tbody>[/TABLE]

Thanks.

Regards

 

[brennann]

Try to see this Bolg. maybe this is what you need. https://exceljet.net/formula/calculate-elapsed-work-time

 

[milhouselucas]

Brennann,

Actually I need to know the time elapsed through those days and not only the difference between each day.

Thank you very much anyway.

 

[Vijaykumar Shetye India]

Dear milhouselucas

Use the formula
=SUM(C1:C10)-SUM(B1:B10)

In the example which you have provided, the result is 4.125, (4.125 days = 99 hours).
It will appear as a different number, depending on the format of the cell.

In case you need to display it in hours as a decimal number, then alter the formula to
=(SUM(C1:C10)-SUM(B1:B10))*24
The result will be 99.

Do let me know if this was your requirement.

Regards,

Vijaykumar Shetye, Goa, India

 

[milhouselucas]

Hi, Vijaykumar!

Thanks for answering me, but I need to know the time elapsed between 01/07/2016 09:00 and 10/07/2016 17:00 counting only the working hours in the table.

Or maybe I dont understand what you propose.

Thank you again.