SOLVED

excel(date-time)

%3CLINGO-SUB%20id%3D%22lingo-sub-2569038%22%20slang%3D%22en-US%22%3Eexcel(date-time)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2569038%22%20slang%3D%22en-US%22%3E%3CTABLE%20border%3D%220%22%20width%3D%22360%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22171%22%20height%3D%2221%22%3E15%2F12%2F20%2011%3A34%3C%2FTD%3E%3CTD%20width%3D%22189%22%3E25%2F12%2F20%208%3A00%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eit%20will%20give%209.8512963%20on%20calculating%20the%20difference%20and%20when%20we%20format%20it%20in%20time%2C%20it%20will%20give%2020%3A25%3A52.%3C%2FP%3E%3CP%3Ehence%20it%20only%20includes%20time%20for%200.8512963%2C%20but%20if%20we%20want%20to%20add%20time%20for%209%20days%2C%20how%20one%20can%20do%20it%20%3F%3C%2FP%3E%3CP%3Ecan%20someone%20help%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2569038%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2569103%22%20slang%3D%22en-US%22%3ERe%3A%20excel(date-time)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2569103%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1108674%22%20target%3D%22_blank%22%3E%40itsDhruv%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EApply%20the%20custom%20number%20format%20%5Bh%5D%3Amm%3Ass%20to%20the%20cell%20with%20the%20difference.%3C%2FP%3E%0A%3CP%3EThe%20square%20brackets%20%5B%20%5D%20around%20the%20h%20make%20Excel%20display%20cumulative%20hours%20(which%20can%20be%20greater%20than%20or%20equal%20to%2024)%20instead%20of%20clock%20hours%20(which%20can%20only%20be%200%20...%2023).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2574966%22%20slang%3D%22en-US%22%3ERe%3A%20excel(date-time)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2574966%22%20slang%3D%22en-US%22%3EThanks%20man!!%20you%20are%20a%20saver%3C%2FLINGO-BODY%3E
New Contributor
15/12/20 11:3425/12/20 8:00

 

it will give 9.8512963 on calculating the difference and when we format it in time, it will give 20:25:52.

hence it only includes time for 0.8512963, but if we want to add time for 9 days, how one can do it ?

can someone help?

 

 

2 Replies
best response confirmed by itsDhruv (New Contributor)
Solution

@itsDhruv 

Apply the custom number format [h]:mm:ss to the cell with the difference.

The square brackets [ ] around the h make Excel display cumulative hours (which can be greater than or equal to 24) instead of clock hours (which can only be 0 ... 23).

Thanks man!! you are a saver