Cable Forum - View Single Post

05-10-2006, 16:32

Hi,

I'm creating an Excel worksheet for overtime.

Our company rules say you can't claim from 07:30 onwards and not before 18:30 for the evening.

I have three columns in the sheet - start time / end time and total hours.

What I need to do is for the user to enter start and end time for the day and for Excel to total the overtime hours BUT taking the above into account...

Anybody know what formula I shoud use for the total column?

Cheers

Lee

05-10-2006, 16:32	#1
LSainsbury Guest Location: Near Hungerford, West Berkshire Services: TV: Sky HD, Landline: BT, Mobile: Orange, Internet: Quite Slow! Posts: n/a	Another Excel question! Hi, I'm creating an Excel worksheet for overtime. Our company rules say you can't claim from 07:30 onwards and not before 18:30 for the evening. I have three columns in the sheet - start time / end time and total hours. What I need to do is for the user to enter start and end time for the day and for Excel to total the overtime hours BUT taking the above into account... Anybody know what formula I shoud use for the total column? Cheers Lee