Solved Need formula for computing # of hrs & shift

June 10, 2015 at 07:03:33
Specs: Windows 7
Start time = 09:00
End time = 19:00
Labor hrs. will then =19:00- 09:00 Result is 10hrs
My issue is what part of those hrs are in 1st shift 8AM to 5PM; what part is 2nd shift or 3rd shift.
Start time and end time is formatted for military whereas my result needs to be Number.
HELP

message edited by LJMx123


See More: Need formula for computing # of hrs & shift

Report •

#1
June 10, 2015 at 07:54:18
Need a bit more info.

1st shift 8AM to 5PM; what part is 2nd shift or 3rd shift.

I can guess the start time for 2nd shift is 5PM
but what are the other times?

How do you need it displayed?
Do you have a column/row that just shows Labor Hours
or some other configuration.

A small sample of what your spread sheet looks like would be helpful
If you wish to post an example, please read this HOW-TO
as it explains the use of the < PRE > tags to align you data so it looks correct.

http://www.computing.net/howtos/sho...

my result needs to be Number.
You mean in a decimal format, not an hourly format, correct?

MIKE

http://www.skeptic.com/


Report •

#2
June 10, 2015 at 08:41:49
✔ Best Answer
Look here for a very good tutorial on time sheets and working with Dates & Times

http://www.cpearson.com/excel/overt...

MIKE

http://www.skeptic.com/


Report •

#3
June 10, 2015 at 08:53:27
Not sure I did this correct w/o pre
6 fields

Start Time End Time Total Hrs 8AM-5PM 5:01PM- 7:59AM Weekends (all hrs.)

Notes:
I have to bill the client on in excel. Once I get the total hours, I don't know how to construct a formula to see how the hours fall into the last 3 fields. Does this help ?


Report •

Related Solutions

#4
June 10, 2015 at 09:38:29
Is this what your sheet looks like:

        A          B          C             D                E              F
1) Start Time   End Time   Total Hrs   08:00-19:00hrs   19:00-08:00hrs   Weekends
2)

Is this a pre existing sheet, or are you designing it?

MIKE

http://www.skeptic.com/


Report •

#5
June 10, 2015 at 09:51:07
Yes Mike you are correct. This based on multiplying the results by 3 different rates (1 for 8-5 PM; 1 for 5:01 to 7:59 and 1 for hrs on the weekend (all hrs)

Report •

#6
June 10, 2015 at 09:57:27
Mike, your separate sheet on times with example was very helpful. I will evaluate and get back to you with success (I hope).
Thanks

Report •

#7
June 10, 2015 at 10:01:34
yes this what it looks like

Report •

#8
June 10, 2015 at 10:24:32
I will evaluate and get back to you

After checking out the template,
just ask, if you have any questions.

MIKE

http://www.skeptic.com/


Report •

Ask Question