I've been trying to work out a spreadsheet for a time sheet. It's for myself in my employed job. I am contracted to work 25 hours a month which is rising to 28 shortly. I can work out the daily hours easily by using hh:mm formatting and subtracting start time from finish time. Where I have a problem is summing the total for the month because (of course) there are only 24 hours in a day.
I've tried doing it cumulatively which again works until I get to over 24 hours.
With your excellent excel knowledge have you any ideas?
Love Excel questions especially when I can answer them.
format the cell in which you are accumulating the hours.
The format that you need is :
[h]:mm
that keeps adding hours regardless.
hope this helps,
Shaun.
__________________
Shaun
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
I wish... Just seem to have a natural affinity for Excel and can't imagine being able to work without it.
Appreciate what Doug says above about there being generic spreadsheets out there but the whole idea of using other peoples work that never seems to completely fit what you want it for leaves me cold.
And besides that, every time you hit a problem you just find new ways of doing things with it.
Its truly jaw dropping how powerful that product is but most people seldom use it for anything more than the basics... Bit like the old ladies in Harrrogate who all seem to have brand new BMW M3's but they never drive them at any more than 30 mph.
I'm waffling again. talk soon,
Shaun.
__________________
Shaun
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
You type a perfectly logical question into the help search facility and it will bring back everything except the answer that your looking for.
It's almost as though you need to know the answer in order to phrase the question in order to find it.
Generally there's more than one way of doing things and the simplest way is always the one that's best hidden in the search facility!
Right, off again. Post acquisition reserves and negative goodwill to play with.
Talk soon,
Shaun.
__________________
Shaun
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
