HI, I have an excel time sheet that employees complete on a monthly basis. The cell format is in (h):mm
this works fine for adding all of the hours and minutes that they work. however, it falls down the following month after a time sheet has been submitted and they then need to deduct hours from the previous month.
EG, the did not work the final day of the month, but were paid for this. therefore. on the new months time sheet they need to deduct -12:00 (minus twelve hours) this works fine when the cells are formatted with general numbers, but excel will not deduct a minus 'time' figure
please help....
Solved by O. B. in 29 mins