Solved: Diferencia de tiempo entre dos horas

Gustavo_Eduardo · 01-25-2022 11:50 AM

Hi all.

I have to calculate the available work time between the time of arrival and the time of departure.

The entry time, ignoring the seconds, for example, can be 8:00 a.m. and the exit time 4:00 p.m.

The idea is to be able to use that time as calculated data for another spreadsheet.

Does anyone know how to do it here?

WillowMobileSys

@Gustavo_Eduardo wrote:
I have to calculate the available work time

I am not sure what is meant by "available work time". Do you mean the amount of time worked?

If you do, then you simply need to perform [End Time] - [Start Time]. The result is a value in Duration type represented as "hhh:mm:ss".

If you wish to get a decimal representation of Hours then you can use this expression - TOTALHOURS([End Time] - [Start Time])

WillowMobileSys

@Gustavo_Eduardo wrote:
I have to calculate the available work time

I am not sure what is meant by "available work time". Do you mean the amount of time worked?

If you do, then you simply need to perform [End Time] - [Start Time]. The result is a value in Duration type represented as "hhh:mm:ss".

If you wish to get a decimal representation of Hours then you can use this expression - TOTALHOURS([End Time] - [Start Time])

Gustavo_Eduardo

Muchas Gracias. Eso es lo que necesitaba. Funcionó perfecto