hours worked (for night workers)

[kris.ball]

Hi All,
I'm new the excel so please be patient, I have created a worksheet that shows the start and finish by worker, I am trying to establish what hours each worker has done per day, this is ok when a worker is on a day shift (eg 11:30 to 23:30) I can just minus the later from the first.. My problem is when a worker has done a night shift and is working (23:30 to 05:30) I don't use date just time example i imput as displayed in the thread, not 25/06/2012 23:30 to 26/06/2012 05:30, i hope that someone can help me as i can't be using the format mentioned as a manual entry everytime.......

[K m]

Assume the start and end time are in cells A1 and B1

Try This:

=IF(B1<A1,24-A1+B1,B1-A1)

Kirk

If this solves your problem, change the title to [SOLVED] and click on the star on the bottom of my message

[Special-K]

This should work
=IF(B1<A1,(1-A1)+B1,B1-A1)

where A1 is start time and B1 is end time, both entered without dates as you've specified

[Pepe Le Mokko]

Simply use

Please Login or Register  to view this content.

and format as required

[kris.ball]

Hi all Thanks for the help but i'm afriad none of these have solved my issue, it may be me and in that case i can't say how sorry i am, i have included a snapshot of the worksheet in hope that this help's

A B C D E F G
1DRIVERS NAME COMPANY CAT DAYS SUN 24TH
2 NIGHTS start timeFinish time
3Aldred Peter ASDA C+E NIGHTS 23:30 05:30
4Bissett Paul ASDA C+E DAYS 08:00 18:30 =F4-E4

the sum is to go in Column G

thanks again for help thus far..

[Fotis1991]

Ηι

Instead of a picture(that you did not uploaded!), why don't you upload a small sample workbook?

[kris.ball]

sorry i didn't know how to do it?

[Fotis1991]

To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

[kris.ball]

test 101.xlsx

thank you

[brian_2me]

=mod(A1-B1,1)

[Fotis1991]

I did not check the other suggestions, but Pepe's formula, works great..

Why do you say that does not works?

[kris.ball]

this does work sorry i had a format issue AND a brain meltdown..... thank you all so much

would you also be able to suggest how to remove 45 minutes off every shift ?? just hoping

[Kevin UK]

=MOD(end_time-start_time,1)-0.03125

[kris.ball]

Thanks Everyone

happy Boss = Pay increase