Trying to add time but it is 1 hour out, where am I going wrong?

%3CLINGO-SUB%20id%3D%22lingo-sub-2941494%22%20slang%3D%22en-US%22%3ETrying%20to%20add%20time%20but%20it%20is%201%20hour%20out%2C%20where%20am%20I%20going%20wrong%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2941494%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22KateS93_0-1636421900734.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F325387i5B590DC9DCE909B3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22KateS93_0-1636421900734.png%22%20alt%3D%22KateS93_0-1636421900734.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20have%20formatted%20the%20cells%20to%20hh%3Amm%20and%20used%20AutoSum%20to%20add%20them.%20It%20is%20showing%2010%20hours%20and%206%20mins%20but%20it's%209%20hours%20and%206%20mins.%20Where%20am%20I%20going%20wrong%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2941494%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2941694%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20add%20time%20but%20it%20is%201%20hour%20out%2C%20where%20am%20I%20going%20wrong%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2941694%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1211955%22%20target%3D%22_blank%22%3E%40KateS93%3C%2FA%3E%26nbsp%3BYou%20are%20adding%206%20hours%20and%2030%20minutes%20to%203%20hour%20and%2036%20minutes.%20That's%2010%20hours%20and%206%20minutes.%20But%20you%20probably%20want%20to%20calculate%20the%20duration%20between%20the%20two%20time%20stamps.%20An%20I%20assume%20the%20times%20are%206%3A30%20am%20and%203%3A36%20pm.%20Use%20%3DF10-E10%20in%20stead%20and%20custom%20format%20the%20cell%20as%20%5Bh%5D%3Amm.%20The%20square%20brackets%20are%20to%20allow%20a%20duration%20longer%20than%2024%20hours.%20Without%20them%2C%20a%20duration%20of%20e.g.%2025%20hours%20will%20be%20displayed%20as%201%3A00.%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

KateS93_0-1636421900734.png

I have formatted the cells to hh:mm and used AutoSum to add them. It is showing 10 hours and 6 mins but it's 9 hours and 6 mins. Where am I going wrong?

1 Reply
@KateS93 You are adding 6 hours and 30 minutes to 3 hour and 36 minutes. That's 10 hours and 6 minutes. But you probably want to calculate the duration between the two time stamps. An I assume the times are 6:30 am and 3:36 pm. Use =F10-E10 in stead and custom format the cell as [h]:mm. The square brackets are to allow a duration longer than 24 hours. Without them, a duration of e.g. 25 hours will be displayed as 1:00.
Edit: The latter is actually demonstrated on the next row.  12:30 + 13:00 = 25:30 which gets displayed as 1:30, i.e. 1 and a half hour past midnight.