Hi all,

This is my first time posting here , hope i will be able to find the
answer i am looking for. I'm very new to vba so please bear with me.

Here goes, this is the problem i'm having at the moment with my
formulas and vba and Excel formulas.

I am currently desinging a roster for my workplace and the problem i am
having is to work out the night shifts. these night shift start at
23:00:00 and end at 06:00:00, now because there is a change in date
between 23:00:00 and 00:00:00 im finding it very difficult to find the
appropriate formula.

Let say the shift worked is starting at: 22:00:00 and ending at
07:00:00, what i would like excel to do is to calculate how many hours
are worked from 22:00:00 to 23:00:00 and from 06:00:00 until 07:00:00
in one cell and in a different cell the time worked between 23:00:00
until 06:00:00, bearing in mind that the finish time can be before
06:00:00 and the start time could be after 23:00:00.
I have tried DateDiff and DateDif and i still have no clue how this is
done.

help me please?

any help would greatly be appreciated.