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
Highlighted
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
Highlighted

@Total125 Perhaps like this?

Screenshot 2020-10-04 at 08.04.12.png

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

@Total125 

The number format should be

[h]:mm

Highlighted
Thank you