formula malfunction

[rizmomin]

Hello:

Please refer to attached file, Sheet3
Here in this sheet, i have formuals to calculate hours worked for certain period between column H and I for employees in cell K1:Q1, data used
are from column A:E which are imported from Sheet1

Not sure but its giving zero as shown.
Please help to identify the problem.


Let me know if you have any questions.
Thanks.

Riz

[FDibbins]

Your Hours (col E) is text not time/value

In fact C:E are all text
So is A

[FDibbins]

For col A...
1. Highlight the date range
2. Select Text2Columns (data tab)
3. click Next/Next, check Date and select the date format you need
4. Click OK

For Col E, use this, copied down...
E2=LEFT(D3,2)&":"&RIGHT(D3,2)-LEFT(C3,2)&":"&RIGHT(C3,2)
Format as needed

[JohnTopley]

The problem appears to be that ALL the data is text: converting column A to Dates and column E to Number solved the problem; use "Data"==>"Text to Columns" to convert.

I think I would be correct in saying this is not the first time this problem has occurred: where does the data originate?