Adding Values Contained in Text cells

[Jess_A]

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...)? 

[#2 · Accepted solution]

@Jess_A 

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

[#3]

Perfect, thank you Sir.

[#4]

@Jess_A , you are welcome