View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Negative hours [h]:mm:ss

hi
the 1900 system wont let you do that as i stated in my post. the 1904 system
seems to let you but i have not worked with the 1904 system. you can try it.
on the menu bar....
toolsoptionscalculate tabcheck 1904 date systemok

Regards
FSt1

"The Rook" wrote:

I am typing a list of hours paid to an employee in a column as follows then
adding them up:

00:30:00
00:30:00
00:32:00
00:28:00
-00:32:00

This should result 01:28:00

But it will not let me enter -00:32:00

Regards


"FSt1" wrote:

hi
00:32:00 is not negitive.
negitive dates and time are displayed as ######

could you be more specific?

Regards
FSt1

"The Rook" wrote:

How can I enter negative hours when formatted as [h]:mm:ss

eg - 00:32:00 = 32 minutes

Regards

The Rook