copy data from 1 sheet to another if a condition is met

%3CLINGO-SUB%20id%3D%22lingo-sub-1561908%22%20slang%3D%22en-US%22%3Ecopy%20data%20from%201%20sheet%20to%20another%20if%20a%20condition%20is%20met%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1561908%22%20slang%3D%22en-US%22%3E%3CP%3Esheet1%20has%20a%20column%20that%20list%20%22employee%20names%22%20and%20a%26nbsp%3B%20column%20for%20their%20%22punch%20in%22%20times.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esheet2%20has%20a%20column%20that%20list%20%22employee%20names%22%20and%20a%20%22start%20work%22%20time%20column.%26nbsp%3B%20(time%20when%20they%20turn%20the%20key%20on%20their%20work%20truck%20and%20we%20have%20a%20system%20that%20records%20the%20time%20and%20we%20call%20it%20%22start%20work%22%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20need%20the%20data%20from%20sheet%202%20copied%20to%20sheet1%20and%20formula%20to%20show%20difference%20in%20each%20employees%20%22punch%20in%22%20time%20and%20their%20%22start%20work%22%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eany%20help%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Edaniel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1561908%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1561958%22%20slang%3D%22en-US%22%3ERe%3A%20copy%20data%20from%201%20sheet%20to%20another%20if%20a%20condition%20is%20met%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1561958%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F747445%22%20target%3D%22_blank%22%3E%40dank1868%3C%2FA%3E%26nbsp%3B%2C%20could%20use%20a%20bit%20more%20explanation.%20For%20example%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20one%20employee's%20details%20from%20Sheet1%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22931%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22108%22%3E%26nbsp%3B%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22128%22%3EEmployee%20Number%3C%2FTD%3E%3CTD%20width%3D%2273%22%3Efirst%3C%2FTD%3E%3CTD%20width%3D%2294%22%3Elast%3C%2FTD%3E%3CTD%20width%3D%22128%22%3EName%3C%2FTD%3E%3CTD%20width%3D%2241%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22134%22%3EStatus%20Description%3C%2FTD%3E%3CTD%20width%3D%2299%22%3EChange%20Type%3C%2FTD%3E%3CTD%20width%3D%22126%22%3E7%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E4560%3C%2FTD%3E%3CTD%3E61355%3C%2FTD%3E%3CTD%3ERobert%3C%2FTD%3E%3CTD%3EContreras%3C%2FTD%3E%3CTD%3EContreras%2C%20Robert%3C%2FTD%3E%3CTD%3E15%3C%2FTD%3E%3CTD%3ECLOCK%20IN%2FPRE-TRIP%3C%2FTD%3E%3CTD%3EManual%3C%2FTD%3E%3CTD%3E2020-07-29%2005%3A53%3A49%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E4560%3C%2FTD%3E%3CTD%3E61355%3C%2FTD%3E%3CTD%3ERobert%3C%2FTD%3E%3CTD%3EContreras%3C%2FTD%3E%3CTD%3EContreras%2C%20Robert%3C%2FTD%3E%3CTD%3E15%3C%2FTD%3E%3CTD%3EIN%20SERVICE%3C%2FTD%3E%3CTD%3EManual%3C%2FTD%3E%3CTD%3E2020-07-29%2006%3A02%3A56%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E4560%3C%2FTD%3E%3CTD%3E61355%3C%2FTD%3E%3CTD%3ERobert%3C%2FTD%3E%3CTD%3EContreras%3C%2FTD%3E%3CTD%3EContreras%2C%20Robert%3C%2FTD%3E%3CTD%3E15%3C%2FTD%3E%3CTD%3EOUT%20OF%20SERVICE%3C%2FTD%3E%3CTD%3EManual%3C%2FTD%3E%3CTD%3E2020-07-29%2016%3A02%3A10%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E4560%3C%2FTD%3E%3CTD%3E61355%3C%2FTD%3E%3CTD%3ERobert%3C%2FTD%3E%3CTD%3EContreras%3C%2FTD%3E%3CTD%3EContreras%2C%20Robert%3C%2FTD%3E%3CTD%3E15%3C%2FTD%3E%3CTD%3ECLOCK%20OUT%3C%2FTD%3E%3CTD%3EManual%3C%2FTD%3E%3CTD%3E2020-07-29%2016%3A22%3A10%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20the%20same%20employee's%20information%20from%20Sheet2%3A%3C%2FP%3E%3CTABLE%20width%3D%22805%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22108%22%3EName%3C%2FTD%3E%3CTD%20width%3D%22128%22%3EHomePlt%3C%2FTD%3E%3CTD%20width%3D%2273%22%3EOnDuty%3C%2FTD%3E%3CTD%20width%3D%2294%22%3EPunchIn%3C%2FTD%3E%3CTD%20width%3D%22128%22%3EPunchOut%3C%2FTD%3E%3CTD%20width%3D%2241%22%3EShift%3C%2FTD%3E%3CTD%20width%3D%22134%22%3EPPD%3C%2FTD%3E%3CTD%20width%3D%2299%22%3EDOT%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EContreras%2C%20Robert%3C%2FTD%3E%3CTD%3E715%3C%2FTD%3E%3CTD%3EYES%3C%2FTD%3E%3CTD%3E2020-7-29%205%3A50%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E14.17%3C%2FTD%3E%3CTD%3E36.67%3C%2FTD%3E%3CTD%3E36.67%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E2020-7-27%200%3A50%3C%2FTD%3E%3CTD%3E2020-7-27%2013%3A07%3C%2FTD%3E%3CTD%3E12.28%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E2020-7-28%205%3A35%3C%2FTD%3E%3CTD%3E2020-7-28%2015%3A48%3C%2FTD%3E%3CTD%3E10.22%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E2020-7-29%205%3A50%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E14.17%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20would%20you%20want%20your%20final%20data%20to%20look%20like%20when%20these%202%20are%20brought%20together%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1564108%22%20slang%3D%22en-US%22%3ERe%3A%20copy%20data%20from%201%20sheet%20to%20another%20if%20a%20condition%20is%20met%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564108%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F747445%22%20target%3D%22_blank%22%3E%40dank1868%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2277%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2260%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22101%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2265%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2297%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22104%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22375%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22340%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2277%22%3E%3CP%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E%3CP%3EEmployee%20Number%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2260%22%3E%3CP%3Efirst%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2295%22%3E%3CP%3Elast%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22101%22%3E%3CP%3EName%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2265%22%3E%3CP%3EHomePlt%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22103%22%3E%3CP%3EStatus%20Description%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%3CP%3EChange%20Type%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E%3CP%3E7%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2297%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22104%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22375%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22340%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2277%22%3E%3CP%3E4560%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E%3CP%3E61355%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2260%22%3E%3CP%3ERobert%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2295%22%3E%3CP%3EContreras%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22101%22%3E%3CP%3EContreras%2C%20Robert%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2265%22%3E%3CP%3E15%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22103%22%3E%3CP%3ECLOCK%20IN%2FPRE-TRIP%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%3CP%3EManual%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E%3CP%3E7%2F29%2F2020%205%3A53%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2297%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22104%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22375%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22340%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2277%22%3E%3CP%3E4560%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E%3CP%3E61355%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2260%22%3E%3CP%3ERobert%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2295%22%3E%3CP%3EContreras%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22101%22%3E%3CP%3EContreras%2C%20Robert%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2265%22%3E%3CP%3E15%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22103%22%3E%3CP%3EIN%20SERVICE%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%3CP%3EManual%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E%3CP%3E7%2F29%2F2020%206%3A02%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2297%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22104%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22375%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22340%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2277%22%3E%3CP%3E4560%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E%3CP%3E61355%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2260%22%3E%3CP%3ERobert%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2295%22%3E%3CP%3EContreras%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22101%22%3E%3CP%3EContreras%2C%20Robert%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2265%22%3E%3CP%3E15%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22103%22%3E%3CP%3EOUT%20OF%20SERVICE%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%3CP%3EManual%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E%3CP%3E7%2F29%2F2020%2016%3A02%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2297%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22104%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22375%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22340%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2277%22%3E%3CP%3E4560%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E%3CP%3E61355%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2260%22%3E%3CP%3ERobert%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2295%22%3E%3CP%3EContreras%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22101%22%3E%3CP%3EContreras%2C%20Robert%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2265%22%3E%3CP%3E15%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22103%22%3E%3CP%3ECLOCK%20OUT%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%3CP%3EManual%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E%3CP%3E7%2F29%2F2020%2016%3A22%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2297%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22104%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22375%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22340%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2277%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2260%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22101%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2265%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2297%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22104%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22375%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22340%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2277%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2260%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22101%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2265%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2297%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22104%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22375%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22340%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2277%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2260%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22101%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2265%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2297%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22104%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22375%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22340%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2277%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2260%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22101%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2265%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2297%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22104%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22375%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22340%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2277%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2260%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22101%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2265%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2297%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22104%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22375%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22340%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2277%22%3E%3CP%3EName%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E%3CP%3EHomePlt%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2260%22%3E%3CP%3EOnDuty%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2295%22%3E%3CP%3EPunchIn%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22101%22%3E%3CP%3EPunchOut%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2265%22%3E%3CP%3EShift%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22103%22%3E%3CP%3EPPD%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%3CP%3EDOT%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E%3CP%3ECLOCK%20IN%2FPRE-TRIP%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2297%22%3E%3CP%3EIN%20SERVICE%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E%3CP%3EOUT%20OF%20SERVICE%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22104%22%3E%3CP%3ECLOCK%20OUT%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22375%22%3E%3CP%3ETime%20Difference%20Between%20PunchIN%20and%20CLOCK%20IN%20PRE-TRIP%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22340%22%3E%3CP%3ETime%20Difference%20Between%20CLOCK%20OUT%20and%20PunchOUT%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2277%22%3E%3CP%3EContreras%2C%20Robert%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E%3CP%3E715%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2260%22%3E%3CP%3ENO%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2295%22%3E%3CP%3E7%2F29%2F2020%205%3A50%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22101%22%3E%3CP%3E7%2F29%2F2020%2016%3A58%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2265%22%3E%3CP%3E14.17%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22103%22%3E%3CP%3E36.67%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%3CP%3E36.67%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E%3CP%3E7%2F29%2F2020%205%3A53%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2297%22%3E%3CP%3E7%2F29%2F2020%206%3A02%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E%3CP%3E7%2F29%2F2020%2016%3A02%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22104%22%3E%3CP%3E7%2F29%2F2020%2016%3A22%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22375%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22340%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2277%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2260%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295%22%3E%3CP%3E7%2F27%2F2020%200%3A50%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22101%22%3E%3CP%3E7%2F27%2F2020%2013%3A07%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2265%22%3E%3CP%3E12.28%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22103%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2297%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22104%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22375%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22340%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2277%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2260%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295%22%3E%3CP%3E7%2F28%2F2020%205%3A35%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22101%22%3E%3CP%3E7%2F28%2F2020%2015%3A48%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2265%22%3E%3CP%3E10.22%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22103%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2297%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22104%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22375%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22340%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2277%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2260%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295%22%3E%3CP%3E7%2F29%2F2020%205%3A50%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22101%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2265%22%3E%3CP%3E14.17%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22103%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2297%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22104%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22375%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22340%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2277%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2260%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22101%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2265%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2297%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22104%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22375%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22340%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2277%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2260%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22101%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2265%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2297%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22104%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22375%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22340%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2277%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2260%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2295%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22101%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2265%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22127%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2297%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22104%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22375%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22340%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EWe%20are%20trying%20to%20determine%20how%20much%20time%20is%20being%20lost%26nbsp%3B%20by%20our%20drivers.%20Kronos%20is%20our%20time%20system%20that%20I%20get%20their%20PunchIn%20time.%20When%20the%20driver%20turns%20the%20key%20to%20truck%2C%20Trackit%20%26nbsp%3Bsoftware%20records%20that%20as%20%E2%80%9CClock%20in%20%2F%20Pre-trip%E2%80%9D%20time.%20Then%20vise-a-versa%20at%20the%20end%20of%20the%20day%20for%20Clock%20Out%20and%20PunchOut.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20end%20results%20we%20are%20looking%20for%20is%20the%20time%20difference%20between%20them%20and%20consider%20it%20as%20a%20loss%20of%20man%20time%20on%20the%20clock.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENotice%20please%204560%26nbsp%3B%20is%20the%20truck%20number%20that%20the%20driver%20has%20logged%20into%20in%20Trackit..%20it%E2%80%99s%20possible%20that%20the%20driver%20could%20log%20into%20and%20out%20of%20different%20trucks%20thru%20out%20the%20day%20but%20all%20needs%20to%20be%20counted%20for%20in%20this%20calculation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20wrap%20it%20all%20up%20in%20a%20pretty%20bow%2C%20a%20graph%20or%20some%26nbsp%3B%20type%20of%20visual%20to%20represent%20these%20times%20would%20be%20awesome..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help%20with%20this%20and%20look%20forward%20to%20any%20help%20you%20can%20give.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESincerely%2C%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CEM%3EDaniel%20Klaes%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EDispatch%26nbsp%3B%20-%20Austin%20Division%3C%2FP%3E%3CP%3EAlamo%20Concrete%20Products%3C%2FP%3E%3CP%3E4200%20Todd%20Ln%20%26nbsp%3BAustin%2C%20TX%26nbsp%3B%2078744%3C%2FP%3E%3CP%3EDispatch%20512.444.6751%3C%2FP%3E%3CP%3EFax%20512.444.2316%3C%2FP%3E%3CP%3E%3CU%3Edklaes%40alamoconcrete.com%3C%2FU%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22dank1868_0-1596499754071.jpeg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F210098iD923AE13AA8E6D94%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22dank1868_0-1596499754071.jpeg%22%20alt%3D%22dank1868_0-1596499754071.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1566559%22%20slang%3D%22en-US%22%3ERe%3A%20copy%20data%20from%201%20sheet%20to%20another%20if%20a%20condition%20is%20met%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1566559%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F747445%22%20target%3D%22_blank%22%3E%40dank1868%3C%2FA%3E%26nbsp%3B%2C%20This%20may%20not%20be%20the%20perfect%20answer%2C%20but%20here's%20my%20attempt%20at%20solving%20your%20problem%20using%20Power%20Query.%20I%20had%20to%20make%20a%20few%20decisions%20to%20fill%20in%20the%20gaps%20of%20my%20understanding%20of%20your%20industry%20so%20review%20carefully.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1588556%22%20slang%3D%22en-US%22%3ERe%3A%20copy%20data%20from%201%20sheet%20to%20another%20if%20a%20condition%20is%20met%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1588556%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383224%22%20target%3D%22_blank%22%3E%40TheAntony%3C%2FA%3Ethank%20you%20for%20your%20help..%20couple%20of%20%3F's%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eat%20the%20end%20of%20each%20day%20i'd%20like%20to%20run%20what%20you%20created%20with%20the%20new%20%22status_raw%22%20and%20%22hour_raw%22%26nbsp%3B%20times%2C.%20can%20I%20do%20this%20and%20how%3F%20can%20you%20save%20the%20workbook%20so%20it%20has%20your%20query%20and%20format%20presented%20to%20me%20as%20a%20new%20sheet%20and%20i'll%20just%20past%20the%20data%20in%20the%20worksheets%20and%20new%20totals%20with%20calculate%2F..%20I%20really%20appreciate%26nbsp%3B%20your%20help%20and%20look%20forward%20to%20your%20next%20mail.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

sheet1 has a column that list "employee names" and a  column for their "punch in" times.

 

sheet2 has a column that list "employee names" and a "start work" time column.  (time when they turn the key on their work truck and we have a system that records the time and we call it "start work" time.

 

i need the data from sheet 2 copied to sheet1 and formula to show difference in each employees "punch in" time and their "start work" time.

 

any help would be greatly appreciated.

 

thanks,

 

daniel

4 Replies
Highlighted

@dank1868 , could use a bit more explanation. For example,

 

Here's one employee's details from Sheet1:

 

  Employee NumberfirstlastName Status DescriptionChange Type7
456061355RobertContrerasContreras, Robert15CLOCK IN/PRE-TRIPManual2020-07-29 05:53:49
456061355RobertContrerasContreras, Robert15IN SERVICEManual2020-07-29 06:02:56
456061355RobertContrerasContreras, Robert15OUT OF SERVICEManual2020-07-29 16:02:10
456061355RobertContrerasContreras, Robert15CLOCK OUTManual2020-07-29 16:22:10

 

Here's the same employee's information from Sheet2:

NameHomePltOnDutyPunchInPunchOutShiftPPDDOT
Contreras, Robert715YES2020-7-29 5:50 14.1736.6736.67
   2020-7-27 0:502020-7-27 13:0712.28  
   2020-7-28 5:352020-7-28 15:4810.22  
   2020-7-29 5:50 14.17  

 

How would you want your final data to look like when these 2 are brought together? 

 

Highlighted

@dank1868 

              

  

Employee Number

first

last

Name

HomePlt

Status Description

Change Type

7

     

4560

61355

Robert

Contreras

Contreras, Robert

15

CLOCK IN/PRE-TRIP

Manual

7/29/2020 5:53

     

4560

61355

Robert

Contreras

Contreras, Robert

15

IN SERVICE

Manual

7/29/2020 6:02

     

4560

61355

Robert

Contreras

Contreras, Robert

15

OUT OF SERVICE

Manual

7/29/2020 16:02

     

4560

61355

Robert

Contreras

Contreras, Robert

15

CLOCK OUT

Manual

7/29/2020 16:22

     
              
              
              
              
              

Name

HomePlt

OnDuty

PunchIn

PunchOut

Shift

PPD

DOT

CLOCK IN/PRE-TRIP

IN SERVICE

OUT OF SERVICE

CLOCK OUT

Time Difference Between PunchIN and CLOCK IN PRE-TRIP

Time Difference Between CLOCK OUT and PunchOUT

Contreras, Robert

715

NO

7/29/2020 5:50

7/29/2020 16:58

14.17

36.67

36.67

7/29/2020 5:53

7/29/2020 6:02

7/29/2020 16:02

7/29/2020 16:22

  
   

7/27/2020 0:50

7/27/2020 13:07

12.28

        
   

7/28/2020 5:35

7/28/2020 15:48

10.22

        
   

7/29/2020 5:50

 

14.17

        
              
              
              

We are trying to determine how much time is being lost  by our drivers. Kronos is our time system that I get their PunchIn time. When the driver turns the key to truck, Trackit  software records that as “Clock in / Pre-trip” time. Then vise-a-versa at the end of the day for Clock Out and PunchOut.

 

The end results we are looking for is the time difference between them and consider it as a loss of man time on the clock.

 

Notice please 4560  is the truck number that the driver has logged into in Trackit.. it’s possible that the driver could log into and out of different trucks thru out the day but all needs to be counted for in this calculation.

 

To wrap it all up in a pretty bow, a graph or some  type of visual to represent these times would be awesome..

 

Thank you for your help with this and look forward to any help you can give.

 

Sincerely,

Daniel Klaes

Dispatch  - Austin Division

Alamo Concrete Products

4200 Todd Ln  Austin, TX  78744

Dispatch 512.444.6751

Fax 512.444.2316

dklaes@alamoconcrete.com

 

dank1868_0-1596499754071.jpeg

 

 

Highlighted

@dank1868 , This may not be the perfect answer, but here's my attempt at solving your problem using Power Query. I had to make a few decisions to fill in the gaps of my understanding of your industry so review carefully. 

Highlighted

@TheAntonythank you for your help.. couple of ?'s

 

at the end of each day i'd like to run what you created with the new "status_raw" and "hour_raw"  times,. can I do this and how? can you save the workbook so it has your query and format presented to me as a new sheet and i'll just past the data in the worksheets and new totals with calculate/.. I really appreciate  your help and look forward to your next mail.