View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
The Rook[_2_] The Rook[_2_] is offline
external usenet poster
 
Posts: 70
Default Negative hours [h]:mm:ss

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