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
|