time

%3CLINGO-SUB%20id%3D%22lingo-sub-1742952%22%20slang%3D%22en-US%22%3Etime%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1742952%22%20slang%3D%22en-US%22%3EHi%20I%20want%20to%20do%20this%20in%20excel%20the%20figures%20are%20hours%20and%20min%3CBR%20%2F%3EHistorically%20our%20wage%20staff%20entered%20contracted%20hours%20into%20our%20system%20without%20the%20unpaid%20break%20(at%205mins%20Per%20hour%20deduction)%20ie%20Sam%20is%20contracted%20to%2040%20hours%20but%20the%20system%20only%20shows%2036%3A40.%20I%20need%20to%3CBR%20%2F%3E36hrs%2040mins%20divide%20by%2055mins%20multiplied%20by%2060mins%20in%20a%20formula%20to%20correct%20everyone%20actual%20contracted%20hours%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1742952%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1742958%22%20slang%3D%22en-US%22%3ERe%3A%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1742958%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F819155%22%20target%3D%22_blank%22%3E%40Total125%3C%2FA%3E%26nbsp%3BPerhaps%20like%20this%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-10-04%20at%2008.04.12.png%22%20style%3D%22width%3A%20262px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F223965i25102F34091C8261%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screenshot%202020-10-04%20at%2008.04.12.png%22%20alt%3D%22Screenshot%202020-10-04%20at%2008.04.12.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1742964%22%20slang%3D%22en-US%22%3ERe%3A%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1742964%22%20slang%3D%22en-US%22%3EThank%20you%20that's%20great%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1742972%22%20slang%3D%22en-US%22%3ERe%3A%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1742972%22%20slang%3D%22en-US%22%3ECan%20I%20ask%20what%20the%20format%20setting%20for%20the%20A1%20cell%20is%20please%3CBR%20%2F%3EThanks%20sam%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1742976%22%20slang%3D%22en-US%22%3ERe%3A%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1742976%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F819155%22%20target%3D%22_blank%22%3E%40Total125%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20number%20format%20should%20be%3C%2FP%3E%3CP%3E%5Bh%5D%3Amm%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
Hi I want to do this in excel the figures are hours and min
Historically our wage staff entered contracted hours into our system without the unpaid break (at 5mins Per hour deduction) ie Sam is contracted to 40 hours but the system only shows 36:40. I need to
36hrs 40mins divide by 55mins multiplied by 60mins in a formula to correct everyone actual contracted hours
5 Replies

@Total125 Perhaps like this?

Screenshot 2020-10-04 at 08.04.12.png

Thank you that's great
Can I ask what the format setting for the A1 cell is please
Thanks sam

@Total125 

The number format should be

[h]:mm

Thank you