Hi,
I am writing a leave tracker spreadsheet and want to add time up to the
minute to keep track of overtime and comp time and credit hours, annual
leave, sick leave etc.

I have my cells formated to time hh:mm but when I add up the time that
equates more than 24 hours, I get ####, which means the calculations are
incorrect.

I tried changing the type to hh:mm:ss and that seemed to add the time up
correctly but I dont want to display the seconds...too much info, plus I
only need up to the min.

any help would be appreciated.

Bill