Does anyone know of a spreadsheet or programme that aids the quick and effecient way of calculating timesheets when emplyess paid by the minute. Rounding to the nearest 1/4 hour is easy but when working in minutes, the calculations take so much longer.
create an excel spread sheet with your list of start and end times. Lets put the start time in cell A1 and the end time in B1
In column C1 enter the formula
=value(b1-c1)
this will give you the time interval in hours and minutes between the two times
A few notes on this.
The time fields must actually be times. Your examples have a "." between the hours and minutes, this must be a ":" (8:26 not 8.26)
The result field must be formated as a time (just right click, format cells, time then choose the time format you want.
Example :
Start
End
Time Worked
08:26
17:51
9:25:00
08:01
16:29
8:28:00
Have fun,
Shaun.
P.S. edited because I wrote dates instead of times. I know that you would know what I meant but changed in anyway.
P.S. edited second time to add the example just to show how I would do it. The time worked field just contains the above formula.
-- Edited by Shamus on Monday 27th of June 2011 12:17:41 PM
-- Edited by Shamus on Monday 27th of June 2011 12:21:52 PM
__________________
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.
Many thanks for this. I have created a new spreadsheet and it works brilliantly and will save me a great deal of time. I did =VALUE(B1-A1) and not C1 as you had stated. I really must get deeper into the bowels of excel when time allows. Once again thank you.
glad you decoded my deliberate test there Roz! (deliberate... yer right!)
Yes, B1 - A1 was what I should have written.
Excel is an astounding product. To my mind the jewel in the Microsoft crown.
You can learn it in a couple of hours and still not know everything about it ten years on.
Shame nobody will pay me to just sit playing with Excel all day :(
__________________
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.
