Thread: NEGATIVE HOURS
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default NEGATIVE HOURS

If you use the 1904 date system in excel, you can use negative time
(tools=options=calculate tab).

However, this will probably make all your dates off by 4 years.

If you want to use decimal number of hours you can

=(a1-a2)*24

--
Regards,
Tom Ogilvy

"André Lavoie" wrote in message
.. .
Would like to cumulate work time in a schedule. I have to compare worked
time to a maximun dayly working time of 7:00 hours. so if I worked 5 hours
out of 7 I would like to obtain minus 2 hours (-2:00) I tried a1-a2

format
to day and time... No succes

Any ideas ???

André Lavoie