Calculating time

Hi guys, I'm brand new to this site and i joined because i need help from the experts.

I just started a new job and i've been tasked with creating a new way of viewing the Shift rota so that it becomes obvious where our unmanned areas are.

The problem i'm having is the night shifts effectively start on one day but finish on the next. I only need to count this as one shift not two.If you like i can email the worksheet to any helpers to illustrate my problem.

Any comments or feedback would be brilliant.

Cheers

Noodles1984

Hi

Over the years i've come up with many ways of working a rota for shifts that go into the next day.

For your overview sheet i would use a 36 hour clock for the working day, that way it wont run into the next week day. (i.e) if you start at 21:00 and finish 05:00 the next day then the new start and finish time would be 21:00 - 29:00

Please find Your sheet attached

See if this gets you started

Dave

Originally Posted by foxguy

Noodles1984;

I looked at your worksheet, and I couldn't find any way to accomplish what you wanted without using a UDF().

If you don't want to use a UDF(), then I would suggest recording the start and end time with dates.
B2 : 6/18/2010 9:00 PM
C2 : 6/19/2010 5:00 AM
If you still waned a visual display of hours worked, it wouldn't be as hard as what you're currently asking for.

FOXGUY,

This answer seems to me to be the best answer for keeping in line with what i wanna achieve,

Can you help me going forward, where do i go from here??

PS: what is a UDF()

Still an excel virgin

Hi,
when searching info on acronyms or others, Google is your friend !

Foxguy, your comments and feedback are much appreciated and i'm ashamed to admit i but your definately right, that would be the answer going forward.

Oh well, back to the drawing board. is it ok if i PM you to ask for help on future projects??

Originally Posted by foxguy

Hi noodles1984;

It's fine to PM me to let me know that you have started another thread and the title to it. Forum Rules ask you to not ask questions in PMs. There are exceptions, so feel free to send me a PM about anything. If I think it should be in a thread where others can see it, I'll let you know. I generally answer the threads that don't get much attention, so if you get a lot of replies, I may not open it, so be sure and PM me with the title.

I keep the current thread in my subscriptions for at least a month after the last reply, so if you add something to this thread in the next month I'll see it.

Thanks Foxguy,

Like i said mate i'm a bit of an excel virgin and i'm being presented with more and more projects for a massive retail distribution firm and i'm running out of answers to some of them.

All help appreciated.