Help
I need a formula that would calculate time for my 3rd shift employees.
This is what I export from another source
The columns look like this
Nane Shift Start Shift Ends
Doe, John "Oct 22, 2012 10:30:00 PM Oct 23, 2012 9:00:00 AM"

I need a formula that will calculate
*Howmany hours were worked on Oct 22 (example on this it would be 10:30p-12am= 1.50
*Howmany Hours were worked on Oct 23rd (Example on this one it would be 12am-9am=9hrs

Can someone please help?

on 10/25/2012, supposed :
Help
I need a formula that would calculate time for my 3rd shift employees.
This is what I export from another source
The columns look like this
Nane Shift Start Shift Ends
Doe, John "Oct 22, 2012 10:30:00 PM Oct 23, 2012 9:00:00 AM"

I need a formula that will calculate
*Howmany hours were worked on Oct 22 (example on this it would be
10:30p-12am= 1.50 *Howmany Hours were worked on Oct 23rd (Example on this one
it would be 12am-9am=9hrs

Can someone please help?

Would a formula that calcs the duration of the shift do? Here's what I
use to calc ElapsedTime as H.MM, where hours are returned to 2 decimal
places...

=IF(AND(Start<"",Stop<""),ROUND(MOD(Stop-Start,1)*24,2),"")

...so for your sample times it shows *10.50* hours. (The IF construct
leaves the ElapsedTime column empty until both Start/Stop times are
entered because I use this 'on-the-fly' when working on client
projects)

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

On Thursday, October 25, 2012 9:49:04 AM UTC-5, wrote:
Help I need a formula that would calculate time for my 3rd shift employees. This is what I export from another source The columns look like this Nane Shift Start Shift Ends Doe, John "Oct 22, 2012 10:30:00 PM Oct 23, 2012 9:00:00 AM" I need a formula that will calculate *Howmany hours were worked on Oct 22 (example on this it would be 10:30p-12am= 1.50 *Howmany Hours were worked on Oct 23rd (Example on this one it would be 12am-9am=9hrs Can someone please help?


Hello it works fine to calcualte total work time. But I need split the total work time work on 10/22 and Total work time on 10/23
So on 10/22 the total hours would be 1hour and 30 minutes and 10/23 would be 9hours So I would need to diffrent forlulas I'm asumming.

and also some shifts are normal day time shifts I already have a formula for those

Hi,

Am Thu, 25 Oct 2012 11:29:24 -0700 (PDT) schrieb :

Hello it works fine to calcualte total work time. But I need split the total work time work on 10/22 and Total work time on 10/23
So on 10/22 the total hours would be 1hour and 30 minutes and 10/23 would be 9hours So I would need to diffrent forlulas I'm asumming.

for 10/22:
=1-MOD(B2,1)
for 10/23:
=MOD(C2,1)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

On Thursday, October 25, 2012 9:49:04 AM UTC-5, wrote:
Help I need a formula that would calculate time for my 3rd shift employees. This is what I export from another source The columns look like this Nane Shift Start Shift Ends Doe, John "Oct 22, 2012 10:30:00 PM Oct 23, 2012 9:00:00 AM" I need a formula that will calculate *Howmany hours were worked on Oct 22 (example on this it would be 10:30p-12am= 1.50 *Howmany Hours were worked on Oct 23rd (Example on this one it would be 12am-9am=9hrs Can someone please he

Thank you that works