SOLVED

Adding Values Contained in Text cells

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3155996%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EAdding%20Values%20Contained%20in%20Text%20cells%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3155996%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3ETo%20calculate%20the%20total%20hours%20worked%2C%20I%20have%20cells%20for%20start%20time%2C%20stop%20time%20and%20hours%20worked.%26nbsp%3B%20My%20formula%20for%20hours%20worked%20is%26nbsp%3B%20%3DTEXT(Stop%20time%20-%20Start%20time)%26nbsp%3B%20E.g.%208pm%20-%202pm%20%3D%206%20hours%20worked.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20then%20want%20to%20add%20the%20total%20hours%20worked%3B%20how%20do%20I%20add%20the%20value%20contained%20in%20cells%20that%20start%20%22%3DTEXT...)%3F%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3155996%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

To calculate the total hours worked, I have cells for start time, stop time and hours worked.  My formula for hours worked is  =TEXT(Stop time - Start time)  E.g. 8pm - 2pm = 6 hours worked.

 

I then want to add the total hours worked; how do I add the value contained in cells that start "=TEXT...)? 

3 Replies
best response confirmed by Jess_A (New Contributor)
Solution

@Jess_A 

Better not to use TEXT and calculate time difference as =MOD(end-start,1)*24 applying General or Number format.

Perfect, thank you Sir.

@Jess_A , you are welcome