C
Col
Dear all,
Having problems with a time calc in Excel.
I have to design a spreadsheet which will be used at various offices within
the company which needs to calculate staff hours worked in a week and also
the amount of rest from one day to the next.
So lets say a member of staff finishes work at 1100 on Monday and then
resumes work at 1300 on Tuesday, that is a rest period of 26 hours.
If I just take one from the other (1300-1100) Excel returns a value of
02:00:00 which is correct as far as Excel is concerned as I need to tell it
the date.
Herein lies the problem, I cannot expect the staff at the offices to input
each cell in the format "25/May/07 17:00" etc as it will be too time
consuming due to the numbers of staff involved..
So if they input the times in the format 13:00 is it possible via some code
to solve the problem. I've tried having the date in one cell and using
INDIRECT to join it and the time cell together without much success.
Any ideas?
Thanks very much for any advice.
Colin.
Having problems with a time calc in Excel.
I have to design a spreadsheet which will be used at various offices within
the company which needs to calculate staff hours worked in a week and also
the amount of rest from one day to the next.
So lets say a member of staff finishes work at 1100 on Monday and then
resumes work at 1300 on Tuesday, that is a rest period of 26 hours.
If I just take one from the other (1300-1100) Excel returns a value of
02:00:00 which is correct as far as Excel is concerned as I need to tell it
the date.
Herein lies the problem, I cannot expect the staff at the offices to input
each cell in the format "25/May/07 17:00" etc as it will be too time
consuming due to the numbers of staff involved..
So if they input the times in the format 13:00 is it possible via some code
to solve the problem. I've tried having the date in one cell and using
INDIRECT to join it and the time cell together without much success.
Any ideas?
Thanks very much for any advice.
Colin.