The Book-keepers Forum (BKF)
The Book-keepers Forum (UK) -> General Book-keeping & Accounting -> spreadsheet for calculating hours
Post Info TOPIC: spreadsheet for calculating hours
semsley


Guru

Status: Offline
Posts: 1329
Date:
spreadsheet for calculating hours
Permalink  

Hope you're about Shaun.

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?

GOW Sheila


__________________

Advice from beyond the grave!!!

E&OE
Doug12


Newbie

Status: Offline
Posts: 4
Date:
Permalink  

Hi,
You can get free excel timesheets from vertex42.com.I know a few who use them and they seem to be ok

__________________
Shamus


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink  

Hi Sheila,

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.
Lisa Jo


Senior Member

Status: Offline
Posts: 107
Date:
Permalink  

wow, Shaun you just know everything.. good on yeh..

__________________
Shamus


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink  

Hi Lisa,

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.
semsley


Guru

Status: Offline
Posts: 1329
Date:
Permalink  

Thanks Shaun, knew you'd know the answer.  I'd tried all sorts including really complex stuff using ((INT cell+cell)*24  by looking in help!!!!!

I don't like using generic spreadsheets created by others either, they never seem to be exactly what I want.

I used to spend ages messing with V and H Lookups when trying to sort out exam results.

__________________

Advice from beyond the grave!!!

E&OE
Shamus


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink  

Hi Sheila,

That is the one downside with Excel.

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.
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.
The Book-keepers Forum (UK) -> General Book-keeping & Accounting -> spreadsheet for calculating hours
Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About