Associate
- Joined
- 4 Jun 2007
- Posts
- 2,290
- Location
- South Wales
Hi guys,
I'm setting up a spreadsheet to work out my work hours, but trying to base it on my clock card at work. Reason being is that the clock machine went fubar on monday and although payroll have said they'll work it out, I don't trust them as far as I can throw them, so I want to make this sheet so I can give that to them at the end of the week.
Layout is basically
--------------------------------
|Day|In|Out|Total|Running Total|
--------------------------------
|___|__|___|____|___________|
The problem is that when the running total passes 24 hours it start again at 00:00, now I know this is because it is working it out based on a day of 24 hours, but I want it to go up to 40 hours and beyond, is there any way around this?
TIA
I'm setting up a spreadsheet to work out my work hours, but trying to base it on my clock card at work. Reason being is that the clock machine went fubar on monday and although payroll have said they'll work it out, I don't trust them as far as I can throw them, so I want to make this sheet so I can give that to them at the end of the week.
Layout is basically
--------------------------------
|Day|In|Out|Total|Running Total|
--------------------------------
|___|__|___|____|___________|
The problem is that when the running total passes 24 hours it start again at 00:00, now I know this is because it is working it out based on a day of 24 hours, but I want it to go up to 40 hours and beyond, is there any way around this?
TIA