Creating a Timesheet

**davesexcel** · 02-24-2007, 01:51 PM

Originally Posted by gycoso3

I haven't had time to review all of the threads but was wondering if someone would be able to advise me what time of formula or how to edit the one I use to figure hours worked and then round it up to the next our for anything 1 minute past the hour or any amount of time worked. Here is the formula I am using... please help =(F5-D5+(F5<D5))*24 We use multiple columns since we are called out on a regular basis... I might be able to get it if someone get point me in the right direction. Thanks GYCOSO3

this formula gets the total hours worked and then rounds the total to the nearest 15 min

=ROUNDDOWN(((E12<D12) E12-D12 (G12<F12) 2-F12)/TIME(0,15,0),0)*TIME(0,15,0)

this rounding function will clock you in at the next 15min mark

punch in at 5:49
rounds up to 6:00

=ROUNDUP(A1*96,0)/96

and of course this will clock you out at the last 15 mark

punch out at 3:40
rounds down to 3:30

=ROUNDDOWN(A1*96,0)/96

**stevethank** · 03-26-2007, 06:44 AM

I have a unit that is 2secs, basically a recording. How do I convert this to mins and hours and check the time at say 200 unit point? The start point of the unit is 7:00AM.
Appreciate any suggestions. Please email to stevethank@yahoo.com
Thanks
Steve

**LizV** · 05-03-2007, 10:21 PM

I'm trying to create a time sheet that will calculate regular time, 1 1/2, and double time. Here is how it is set up:

Total Time Reg. 1 1/2 Double
20 8 4 8

Is there a way when you input the total time it will break it down?

Thanks for any help with this.

Liz

**philmcracken** · 05-14-2007, 04:03 PM

I have a situation where i need to track employee labor hours. These employees get paid overtime on any hours worked outside of 8am and 4:30 pm and after working 14 hrs they get double time. I would like to be able to just put in the employees start time and end time and have the spreadsheet calculate their number hours worked and how many of those hours were straight time, overtime and double time.

For example employee starts at 6am and ends at 10pm. I would like to input start time of 6am in column 1 and input end time of 8pm in column two. Then have the spreadsheet calculate straight time hours in column three (8am to 4:30pm = 8.5 straight time hrs), have spreadsheet calculate Overtime hours in column four (6am-8am and 4:30pm to 8pm = 5.5 overtime hours). In column five i want the spreadsheet to calculate double time hours (8pm-10pm = 2 double time hours). And finally sixth column total hours.

Columns 3, 4, & 5 present the challenges to me. Anybody have any solutions?

phil

Thread: Creating a Timesheet

Thread Tools

Display

conversion of unit of 2sec to mins and hours

Overtime Calculating

Calculating Overtime and Double Time Hours based on time of day

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions