Hi,

How do i compute for the number of hours that fall into the Night Differential hours within an employees shift? In one cell is the shift start time of an employee and on the other cell is the shift end time. There is no constant number of hours that an employee should complete. Night Differential time starts at 10:00 PM and ends at 6:00AM.

Thanks

How do i compute for the number of hours that fall into the Night Differential hours within an employees shift? In one cell is the shift start time of an employee and on the other cell is the shift end time. There is no constant number of hours that an employee should complete. Night Differential time starts at 10:00 PM and ends at 6:00AM.

Thanks

- To display number of hours and minutes and use it for calculation purpose.
- Formula for determining number of hours?
- Formula for determining end date after N number of hours
- Calculating numbers of hours worked in pay divisions
- Calculate Number Of Hours By Conditions
- Counting number of hours/minutes
- Compute number of hrs
- Counting number of hours per project per team
- Convert dd:hr:mn:ss to Decimal number of hours
- How can I multiply number of hours and minutes by hourly rate?
- Number of hours worked between 18:00 and 06:00
- Calculating number of hours accross days
- Generate sheet by number of hours on shift.
- Calculate number of hours between two date/time combinations
- Formula for showing number of hours used in a work week
- Number of hours worked between 18:00 and 06:00
- The number of hours in a day cannot exceed 24...
- Calculating number of hours between two days
- Formula to work out number of hours spent
- Calculate number of hours in timesheet
- Calculating number of hours worked for an odd shift
- Calculating number of hours accross days
- Calculating the number of hours and minutes between 2 times
- Calculating the Number of Hours per Month, Allowing for Daylight-Saving Shifts

I have a column to state the number of hours of overtime and to multiply it with the hourly rate in another. My question are

1) how to show the column express in hours and minutes like 1.30hrs or 1 hour 30 min?

2) can it be used for calculation purpose?

Thank you so much for your advise.

9:00-12:30, or 1:30-3:00 etc. so that I could use result and multiply it

times number of days and have total hours? Guess it would involve conversion

to 24 hr clock?

I am attempting to create a formula in which I can feed the start date, and number of hours the class is to produce the end date of the class as output.

In the past I have used the WORKDAY function and it works flawlessly. However, this course has an odd schedule. Mondays and Tuesdays are 8.5 hours, and Wednesdays are 8 hours. The hours each class runs for are not necessarily divisible by these days either so there will be partial days. This can simply be rounded to the next day.

SOO ... is there a formula or macro that can take a start date, run through the calendar adding up the varying hours until the minimum number of hours for the course have been reached? I also need a way to exclude days just like with the WORKDAY function.

Any assistance is greatly appreciated!

I have a series (couple of hundred thousand spead over several sheets) of start and end dates and times of shifts and I want to be able to calculate for each shift the number of hours worked in each of the different pay divisions we use.

These divisions are, daytime (7:00 am to 7:00 pm), evening (7:00 pm to 7:00 am) and Saturday and Sunday and public holiday.

For example a shift starting at 8:00 pm on a Sunday and ending at 10:00 am on a Monday would be 4 Sunday hours, 7 night hours and 3 daytime hours. That kinda malarkey.

I've been messing around with this for an age and have got some ludicrously overly-complicated nested ifs that will calculate daytime hours but then if I want to add in the Saturday and Sunday portions it will break me. Can anyone help and save a poor wretch like me.

Regards,

Andy

So, I created a drop down list for them to select their names, and a drop down list to select the programs that they taught.

I would like a formula that looks up whenever an Instructor teaches and can calculate the number of hours they taught each class. And, the total number of hours they taught.

Ex.

A1 B1 C1

Bugs PALS 3 hours

Harry PALS 6 hours

Sally BLS 4 hours

Jim BLS 5 hours

Jim ACLS 2 hours

Sally BLS 3 hours

Sally PALS 1 hour

So, based on above, the formula would be able to calculate that Sally taught 1 hour of PALS. Sally taught 7 hours of BLS. And, in total she taught 8 hours.

Is there anyway that I can do this?

I have a spreadsheet which is used to count total number of hours spent on a specific task.

Column C: has date/time started

column E: has date/time paused

column G: has date/time resumed

and Column I: has date/time closed

so basically i need it to count the numbers of hours it takes from:

(date/time started) to (date/time paused) + (date/time resumed) to (date/time closed)

so far it is easy.. now comes the part i cant figure out. sometimes the days shift and I only need to include hours that are between 8am and 5pm and I need to exclude weekends.

so for example if i have

date/time stated = 8/4/2008 4:00pm

date/time paused = 8/4/2008 4:30 pm

date time resumed = 8/5 /2008 9:am

date time closed = 8/6/2008 10am

the total time should be:

30min + 8hrs + 2 hrs(due to day starting at 8 am and task being complete at 10am) = 10 hours 30 min or 10.5 hours

this was an example of straight week days. but if a date range extends over a weekend I need to exclude those hours.

Can anyone point me in the right direction on how to go about writing either some vba code for this, or if there is a function already developed in excel that can help me?

Thank you so much in advance.

I am stuck with a challenge, which I wanted to share with you !

I am managing multiple projects, which are executed by multiple teams. I

want to keep track of the hours spent per team per project.

I want to get that information from the following columns:

Column A Project identification (project 1, Project 2, Project 2, etc)

Column B Name of executing team (Team 1, Team 2, Team 3, etc)

Column C Number of hours spent

The display should be in a new tab:

Project Team # of hours

PR 1 Team 1

PR 2 Team 2

PR 3 Team 3

PR 4 Team 4

Can you please help me out ?

Thank you very much for helping me out !!

Jaydubs

time into a decimal number of hours.

I tried the INT command which I've used before for hours but it only

converts the hours in my original cell??

Thanks

each client so I can have total billable hours for each client at the end of

the month. This works fine but I would like to take it one step further and

put in an hourly rate for each client and let Excel calcuate the amount to

invoice at the end of the month.

The problem I am having is that I can't seem to separate the hours from the

minutes to do the calculation properly. Right now I hve a single cell

formatted with the total monthly hours and minutes. Often this number is

greater than 24 hours (ie 35:28). I want to multiply the total number of

hours and minutes by a dollar value and come up with a total dollar value for

the month.

The MINUTE function seems to take care of the minutes fine. However the HOUR

function divides by 24 and returns only a number less than 24. This is not

acceptable for billable hours greater than 24 per month.

Any ideas about how to get the right total?

go beyond 18:00, but end at 06:00. I can't figure out a formula to

calculate the number of hours an employee works between these time

periods.

Examples: An employee works 00:00-08:00, they would earn a special pay

rate for the six hours worked from 00:00-06:00

or

An employee works 16:00-24:00, they would earn a special rate for the 6

hours worked from 18:00-24:00.

or

An employee works 12:00-20:00, they would earn a special rate for the 2

hours worked from 18:00-24:00

Help!!!! Anybody with an answer?????

--

clobns

------------------------------------------------------------------------

clobns's Profile: http://www.excelforum.com/member.php...o&userid=28550

View this thread: http://www.excelforum.com/showthread...hreadid=482099

I need help calculating aging in hours across multiple days.

For the example below, how would I calculate the number of hours between the

start date and end date?

Thanks

Start Date = 8/11/2006 5:05

End Date = 8/14/2006 17:58

How do I calculate the number of hours between start and end date?

Please can some assist me. Desparate in need of help.

I have attached the spreadsheet.

User key in the number of hours on shift in cell J46.

And

I want spreadsheet to be generated for that many hours.

http://i47.tinypic.com/rjqnpc.jpg

http://i47.tinypic.com/rjqnpc.jpg

example if cell J46 has 10 then i want row 5 to 14 to be generated.

If cell J46 has value 4 the i want row 5 to 9 to be generated.

Please could some assist me i have give this project in by 9am tomorrow.

Appricate anyone help.

I am trying to find a way to calculate the number of hours between date/times found in separate rows. The attached data set will help to envision what I am talking about.

For each couple of rows, I need to find a way to calculate the number of hours elapsed from row 1 to row 2. In the first example, to calculate the number of hours between 12/2/2009 8:56:51 and 12/4/2009 6:35:27.

any help is appreciated!

Thank you

anyone know a formula that would show me the number of hours from start of workweek (Monday 7am) until whenever a workbook is opened during that week?

Thanks.

Examples: An employee works 00:00-08:00, they would earn a special pay rate for the six hours worked from 00:00-06:00

or

An employee works 16:00-24:00, they would earn a special rate for the 6 hours worked from 18:00-24:00.

or

An employee works 12:00-20:00, they would earn a special rate for the 2 hours worked from 18:00-24:00

Help!!!! Anybody with an answer?????

I have a spreadsheet that is used to manage time sheets and invoices.

The weekly time sheets are on separate tabs and the invoice is at the

beginning. The invoice tab uses no special cell content type but Excel

seems to thing all of the cells on that tab are formatted to "Time" and

anything I try to enter into these cells causes an error that "The

number of hours in a day cannot exceed 24". The cell is formatted as

text, plain text. Why would this restriction be there?

Sometimes I can generate the data in another spreadsheet and copy

things into the invoice's cells. For example: I copy "234" from a

blank sheet into the invoice, the cell value changes. If I try to

manually type that same value into that same cell, I get the error. If

I copy the contents from the blank sheet and then edit the cell, I get

the error.

Does anybody have any ideas as to how I can completely reset the

contents of a cell such that it will allow normal text entry again?

Thanks!

Mike

For instance if I subtract 21-10-2005 12:10:00 from 22-10-2005 14:10:00

Excel should give 26:00:00 as the result. Can anyone answer?

in A1 i have a time and Date format eg: 03/02/2012 10:40:00

in B1 i have another date and time eg: 06/02/2012 09:00:00

the out come is to be in C1 which tells me the number of hours between the first date and the 2nd

thanks for your help in advance

Regards

James

I need help calculating aging in hours across multiple days.

For the example below, how would I calculate the number of hours between the

start date and end date?

Thanks

Start Date = 8/11/2006 5:05

End Date = 8/14/2006 17:58

How do I calculate the number of hours between start and end date?

I'm using the formula:

=TEXT(C3-B3,"h:mm")

When B3=4:00 pm and C3=12:00am, I'm getting an error. I'd like it to output 8:00 (representing the 8 hours between 4pm and 12am. Any ideas ?

Calculating the number of hours that constitute each month (serial number) listed in column A.

One hour should be subtructed to April due to the shift to daylight saving time.

Similarly, one hour should be added from October's total due to the shift back to standard time.

Solution:

Use the DAY, EOMONTH, and DATE functions as shown in the following formula:

=DAY(EOMONTH(DATE(2005,A2,1),0))*24-(A2=4)+(A2=10)

No luck finding an answer? You could always try Google.