calculations with cells referencing other sheets in workbook

[Karen]

I have a worksheet with time functions that I need to sum. The values were imported using string then converted to time
on one of the sheets in the workbook. Those values are then referenced on other sheets where I would like to SU
their values. The times are pulled in and displayed correctly on the initial cell, however when that 2nd cell is use
in a formula, the return is 0:00:00. Help.

 

[JE McGimpsey]

How are you converting the strings to time?

 

[Karen]

I am opening with excel import wizard and identifying times as text. Once done I covert with =TIMEVALUE("00:"&F2) to convert time to 37:30:55 format.

 

[David]

Hi Karen
When I try this out the imported text is text ie I had to put " ' " in front of it for the formula to work ie =TIMEVALUE(C1). The formula would not allow me to use "real time" ie 9:00 AM did not work, "Text Required." The return is a fraction of 24 hours, which can be added. Do not know if this helps or not

----- Karen wrote: ----

I have a worksheet with time functions that I need to sum. The values were imported using string then converted to time
on one of the sheets in the workbook. Those values are then referenced on other sheets where I would like to SU
their values. The times are pulled in and displayed correctly on the initial cell, however when that 2nd cell is use
in a formula, the return is 0:00:00. Help.