Calculating Hours

**Ryan Tonic** · 01-08-2011, 06:51 PM

Hi,
I'm trying to make my roster automatically work out the amount of hours if I put into a cell 11-16 being 11am-4pm being 5 hrs, each cell is someone's shift times, if there is a split shift it'll read 11-16 19-2 .
Please help
I've attached a copy
Ryan

**DonkeyOte** · 01-08-2011, 06:59 PM

Ryan, welcome to the board.

As you will note I have moved your post from the original thread in which it was posted to your own dedicated thread.
We ask that members do not post their own questions in the threads of other members.
If you feel another thread is especially relevant to your own question by all means provide a link to that thread from within your own post.

In short, please endeavour to post in accordance with the Forum Rules going forward

Thanks in advance.

**Ryan Tonic** · 01-08-2011, 07:13 PM

Thats no problem at all and thanks!!

**Ryan Tonic** · 01-08-2011, 08:03 PM

PLEASE HELP

Hi,
I'm trying to make my roster automatically work out the amount of hours if I put into a cell 11-16 being 11am-4pm being 5 hrs, each cell is someone's shift times, if there is a split shift it'll read 11-16 19-2 .
Please help
I've attached a copy
Ryan