SOLVED
Home

Calculate Difference on Time

%3CLINGO-SUB%20id%3D%22lingo-sub-356690%22%20slang%3D%22en-US%22%3ECalculate%20Difference%20on%20Time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-356690%22%20slang%3D%22en-US%22%3E%3CP%3EI'd%20like%20to%20ask%20for%20help%20regarding%20a%20%23VALUE%20error%20I%20am%20receiving%20when%20subtracting%20time%20duration.%20End%20Time%20-%26nbsp%3B%20Start%20Time.%20I%20use%20the%20simple%20formula%20%3DD4-C4%20but%20the%20error%20shows%20on%20E4%20cell%20where%20the%20formula%20was%20typed.%20I%20tried%20changing%20the%20region%20settings%2C%20format%20settings%20but%20still%20the%20error%20shows.%20When%20I%20typed%20in%204%20in%20cell%20A10%20and%26nbsp%3B%208%20in%20B10%2C%20then%20%3DB10-A10%2C%20the%20formula%20worked%20giving%204%20as%20an%20answer.%20I%20also%20changed%20the%20cell%20formatting%20to%20time%20but%20still%20the%20error%20appeared.%20I%20also%20tried%20custom%20setting%20but%20still%20unsuccessful.%20Can%20you%20help%20me%20fix%20the%20error%20please%3F%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20343px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F84419i661F97DA60B534F6%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22excel%20value%20error.PNG%22%20title%3D%22excel%20value%20error.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-356690%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-356730%22%20slang%3D%22en-US%22%3ERe%3A%20Calculate%20Difference%20on%20Time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-356730%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Calibri%22%3EAmazing!%20That%20worked!%20Thank%20you%20for%20the%20help%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3C%2FFONT%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-356727%22%20slang%3D%22en-US%22%3ERe%3A%20Calculate%20Difference%20on%20Time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-356727%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F291282%22%20target%3D%22_blank%22%3E%40bea22%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFrom%20your%20screenshot%20it%20looks%20like%20your%20times%20are%20aligned%20to%20the%20left%20of%20the%20cell%20which%20indicates%20they%20have%20been%20entered%20as%20text.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EChange%20the%20cell%20format%20to%20General%20and%20try%20typing%20them%20in%20again.%26nbsp%3B%20%26nbsp%3BIt%20should%20then%20work%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWyn%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

I'd like to ask for help regarding a #VALUE error I am receiving when subtracting time duration. End Time -  Start Time. I use the simple formula =D4-C4 but the error shows on E4 cell where the formula was typed. I tried changing the region settings, format settings but still the error shows. When I typed in 4 in cell A10 and  8 in B10, then =B10-A10, the formula worked giving 4 as an answer. I also changed the cell formatting to time but still the error appeared. I also tried custom setting but still unsuccessful. Can you help me fix the error please?excel value error.PNG

 

2 Replies
Solution

Hi @Deleted 

 

From your screenshot it looks like your times are aligned to the left of the cell which indicates they have been entered as text.

 

Change the cell format to General and try typing them in again.   It should then work

 

Wyn

Highlighted

Amazing! That worked! Thank you for the help @Wyn Hopkins 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies