function for to calculate night shift and hours currents

[juanfrasantos]

Hi, I need a function that calculates the daytime and nighttime hours within a shift, for example 16 hour of entry to 01 hour of departure of de next day, from 16 to 22 = 6 hours (daytime), and from 22 to 01 of the next morning = 3 hours (nighttime), total hours = 9 hours

thanks for all

[VictorN]

Did you try to use Date data type variables?

[juanfrasantos]

Did you try to use Date data type variables?

yes, but I do not know much about programming, I do not know how to do it

[VictorN]

yes, but I do not know much about programming, I do not know how to do it

Then learn the programming!
And search for the reliable sample code!

[juanfrasantos]

i search but not find sample code about this, please help me, thanks

[DataMiser]

Have a look at the DateAdd() and DateDiff() functions