time schedule

[william marinho]

Good morning, I must make a time schedule that tells me how many hours in the night shift i have worked, night shift is between 22:00 and 05:00 in the morning of the next day.
I am using this formula =IF(H17>=V$15;MOD(W$15-H17;1);IF(H17<=W$15;MOD(W$15-H17;1);(IF(K17>=V$15;MOD(K17-V$15;1);IF(K17<=V$15;MOD(K17-V$15;1);0))))) but if I work in a time different of 22:00 to 05:00 lets say 13:00 to 19:00 the cell shows me 21:00 when it should show 00:00. How can I fix it?

 

[william marinho]

All right I will try again and let you know the result

 

[william marinho]

All right my friend, it is working now, the only problem now is lets say, if I work from 00:00 to 06:00am, the couting should stop at 05:00.
This is to correct some errors from HR, so in this cell I only need to count the time between 22:00 to 05:00, all the work performed in other time schedule I have other cells for them. Thanx again for your help!!!

 

[Bosquedeguate]

All right my friend, it is working now, the only problem now is lets say, if I work from 00:00 to 06:00am, the couting should stop at 05:00.
This is to correct some errors from HR, so in this cell I only need to count the time between 22:00 to 05:00, all the work performed in other time schedule I have other cells for them. Thanx again for your help!!!

Ok … can you make that correction or do you need help?
I think you have enough info to make that adjustment.

Please mark the Post that provided the solution to your problem.
Muchas gracias!