# Solved Need formula for computing # of hrs & shift

June 10, 2015 at 07:03:33
Specs: Windows 7
 Start time = 09:00End time = 19:00Labor hrs. will then =19:00- 09:00 Result is 10hrsMy 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.HELPmessage edited by LJMx123

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

#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 5PMbut what are the other times?How do you need it displayed?Do you have a column/row that just shows Labor Hoursor some other configuration.A small sample of what your spread sheet looks like would be helpfulIf you wish to post an example, please read this HOW-TOas 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?MIKEhttp://www.skeptic.com/

Report •

#2
June 10, 2015 at 08:41:49
 Look here for a very good tutorial on time sheets and working with Dates & Timeshttp://www.cpearson.com/excel/overt...MIKEhttp://www.skeptic.com/

Report •

#3
June 10, 2015 at 08:53:27
 Not sure I did this correct w/o pre6 fieldsStart 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?MIKEhttp://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 youAfter checking out the template, just ask, if you have any questions.MIKEhttp://www.skeptic.com/

Report •