Thread
:
Calculating time for 3rd shift
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
GS[_2_]
external usenet poster
Posts: 3,514
Calculating time for 3rd shift
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
Reply With Quote
GS[_2_]
View Public Profile
Find all posts by GS[_2_]