HOW TO FIX A FORMULA

Question

I am newer to excel and trying to do a time sheet on excel. on my hours worked column i keep getting this #valueand I don't know what I am doing wrong.

my formula i am using is =(D2-C2-E2)

Answer 1

The #VALUE! error happens in Excel when you try to perform calculations on values that Excel doesn’t recognize as proper numbers or times. In your formula =(D2-C2-E2), the likely problem is the BREAKS column (E2). You entered :30 and :15, which Excel does not automatically interpret as a time value. Excel needs a full time format like 0:30 for 30 minutes or 0:15 for 15 minutes.

To fix this, update the BREAKS column so that the times are recognized by Excel. For example, change :30 to 0:30 and :15 to 0:15. Then your formula will work correctly.

Also, make sure the START TIME and END TIME are formatted as Time in Excel. You can do this by selecting the cells, right-clicking, choosing Format Cells, and selecting Time. The HOURS WORKED cell should be formatted as [h]:mm to display hours and minutes correctly.

Your corrected formula remains the same:

=D2-C2-E2

After this, Monday and Tuesday should calculate correctly.

---

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin