Spoon feed me some spreadsheet formula?

[ipodsandguns]

Okay so Im making a Spreadsheet to do rotas at work and work out costing.

Iv not done any spreadsheet work for about 8 years now! I remembers the basics but not quite enough.

So far I have put a formula together to add up a colleagues total hours for the week. Pretty simple but I need to slide an if statement to it.

Im wanting a some thing like IF <5:00 - 0:30 to take away un paid breaks.

Im tripping up on the time formats so in places Im using custom format codes such as [H]:MM to add up the hours as units.

So add up the total hours for a colleague iv using the un-elegent

=SUM(D5-C5)+(F5-E5)+(H5-G5)+(J5-I5)+(L5-K5)+(N5-M5)+(P5-O5)

But it works so far.

Cheers up front.

Dan

X

Youd think ASDA would have software to do this...

 

[AK]

If no one has sorted by tomorrow I'll do it at work.

 

[ipodsandguns]

Cheers, Im using Open office btw but I dont think that will make a difference.

 

[The Boosh!]

I don't get what you're asking mate? If a value is less than 5 hours you want to take off 30 minutes?