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
|