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?
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])
Muchas Gracias. Eso es lo que necesitaba. FuncionĆ³ perfecto