Spread sheet help needed

wiggyuk · 3 Dec 2007 at 13:35

Hi all, I am trying to do a spreadsheet to work out staff working hours.

For e.g

Start 12:00
Finish 17:00
this is ok it shows me that they worked 5 hours

Start 17:00
Finish 03:00 the next day
this is wrong shows up -14 hours instead of 10 hours ?

is the a easy way around this ?

wiggyuk · 3 Dec 2007 at 13:47

Tomsk said:
=IF(start<finish,finish-start,1+finish-start)

You have lost me ?

chrismox said:
Assuming start time is in cell A1 and end time is A2:

=IF(A2<=A1,(A2-A1)+1,A2-A1)
Cell format for A1 & A2 is Custom - hh:mm
Cell format for the result is Custom - [h]:mm

Make sense?

EDIT - Beaten to it!

Cheers mate, thats sorted it.

wiggyuk · 3 Dec 2007 at 14:12

Im still confused please see the attached file.

http://www.mediafire.com/?anyh92mtg1y

wiggyuk · 3 Dec 2007 at 14:47

chrismox said:
You have mail.

There are hidden cells that, if you unhide, you'll see what I've done.

I've only changed the top table, not the bottom one.

Cheers mate, will take a look

wiggyuk · 3 Dec 2007 at 15:36

Cheers chrismox, I have had a look and that great but for some reason its not calculating the correct cost now, which should be hours worked * hourly rate - breaks ??

wiggyuk · 3 Dec 2007 at 16:20

Can any of you guys help, please !