Thread: Creating a Timesheet

Hi,

Not sure where the best to ask this is so i'll do it here.

I have a h:mm time which i need to get converted into days/hours/minutes, creating an on the fly phrase of something like "2 days, 4 hours, 32 mins" for example.

eg: 26:45 (hours/minuts) to be converted to "1 day(s), 2 hours, 45 minutes"...

Any help would be great, email me?
ben@bdesigned.co.uk


Thanks,
Ben

I was wondering how would you add hours (for example time that it takes to complete a task) with a start date of lets say today 6/2/2006, and figure out the end date. Keep in mind the work week is 4 days long Monday through Thursday and then do the same thing this time using the full seven days of the week. Can this be even done with excel if so can you then edit the formula to exclude holiday dates? Please advice

then give me the total hours worked for that projects.

I work for a Arch/Contruction company, each job has it's own project number and name, but it the timesheet there's a breakdown of descriptions, I need grand total throughout timesheet.

Thanks

Kate

Hey all

Needing a timesheet to handle multiple employees with time entered as follows:

830a
945p
1252a

It needs to be able to deduct lunch breaks and caclulate overtime based on a 40 hour work week that starts on a Sunday and ends on a Saturday/Sunday crossover (so if you started your shift on saturday and ended it after midnight, the hours after midnight still count correctly as a Saturday shift).

it ALSO needs to be able to handle pay periods starting on the 1st and on the 16th of each month (this won't effect anything on the timesheet itself, but will effect the Pay calculator i'm trying to tie into it).

I found a great starting point here:

http://www.cpearson.com/excel/overtime.htm

the problem is that i can't come up with a good way to set the conditions of overtime.

Conditions:
Workweek starts on Sunday Morning (generally around 8am, but can start anytime sunday morning).

Workweek ends on Saturday Night/Sunday Early morning (generally around 3am, but can go a lil bit later sometimes).

Regular Workweek consists of 40 hours. anything over is overtime.

Certain holidays are paid, but don't count for overtime. the Holiday pays for 8 hours Regular Rate (standard shift) if you do not work. The holiday pays the amount of time worked at Double Rate if you work that day. If the holiday falls into overtime, you get Double and a half

ANy help?

I've calculated the difference in h:mm by using the TEXT(A1-B1,"h:mm") but I need the result to remain as a Number so I can then sum hours for a monthly total.

I need to create a daily timesheet with the start time @ 6pm the end time after midnight sometimes. I also need this sheet to deduct lunch breaks. I can get the formulas for the times before midnight, but not after. I know the basics of excel but not overly experienced with it. Can you help me please, this is starting to make me nuts.

I need to create a daily timesheet with the start time @ 6pm the end time after midnight sometimes. I also need this sheet to deduct lunch breaks. I can get the formulas for the times before midnight, but not after. I know the basics of excel but not overly experienced with it. Can you help me please, this is starting to make me nuts.

Hi
I would like to run my spreadsheet in actual hourly time. e.g. 4:30 as opposed to 1630. What formula can I use to convert the cells to acutal time and then total the columns correctly? Right now when I add 7.30 and 7.30 or seven hours thirty minutes, I get 14.60. and I need it to say 15 hours.

Any help?

[QUOTE=Owl527]I have a spreadsheet contain a sequence of procedures and I need timestamp for each task being done. how do you get a timestamp at a specific field? currently I am typing the time in, is there a faster way to do it?

Try this... Format the timestamp cells for what you need; i.e. date & time, just the time. Then just use the quick key combo CTRL + ; (semi-colon)

Dave B. McKeever

I was trying to calculate the hours worked for a single employee on a specific day. Went crazy trying to get the thing to work. This simple formula worked for me.
Values...
Column A = time in, Column B= Time out (sometimes after midnight)
Column C = Total hours worked.
Make sure all your cells are formatted to the 24 hr clock (13:30)
FORMULA
=(24-A2+B2)

Use the 24 hrs. minus the time in + time out.

It seemed to work for me.

Problem:

Creating a timesheet calculating the number of hours worked each day, and their total.
Solution:

Create 3 columns containing the following data: Date, Time In, Time Out.

In the 4th column (Number of Hours), enter this formula:
=(C2-B2+(C2

To sum the total of hours worked, use this formula:
=SUM(D2:D7)

Example:

Date________Time In_____Time Out
4/11/2005___09:00________17:00
4/12/2005___10:30________19:00
4/13/2005___08:30________17:30
4/14/2005___11:00________16:00
4/15/2005___12:00________0:30
4/16/2005___09:30________16:45



Number of Hours
8.00
8.50
9.00
5.00
12.50
7.25

Total Hours 50.25

Hey,

How do you calculate the total number of hours you have worked - in maybe lets say a week?

When I use the function “=sum()” or “+” I get the wrong number of hours because it starts counting over again after 24h.

Fx. 8h+10h+10h=4h

All help welcome at cabo04ae@student.cbs.dk

ASP

Martin Borcher

Hi Martin

Change your cell formatting from e.g. hh:mm to [h]:mm - this will force Excel to display 46:23 instead of 22:23.

Thanks you for every thing. Now I can keep in trak on my time card...

Hi I would like to total the amount that is due at the the end of the week based on hourly rate, the problem is it does not seem to acknowledge the minutes on the total, can you help?

Reply to amanda.parga@slam.nhs.uk