negative time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i display negative time? i have an overtime worksheet and i want to
subtract time to represent time missed.
 
Hi

Set the calendar format to 1904 in Tools > Options.

Note that dates will shift 4 years 1 day if you have dates in there. Post
back if that's a problem.

HTH. Best wishes Harald
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Overtime Calculation 2
formula for hours on time sheet 4
subtract times with a negative result 1
Red cell for negative numbers in Excel 1
Add/Subtract hours 3
How do I replace a negative number at the end of a formula with a. 5
Negative time displayed as ####### 8
need help w/ formula for taking lunch & overtime out of a 9 hour 2

Back
Top