I would like to subtract hours, not time of day and have it end up in h:mm
format. currently I am subtracting a cell with hours in h:mm format from a
cell in number (0 decimal places) format with the following formula:

=((HOUR(E18)*60)+MINUTE(E18)-($I$8*60))/60

As an example the cell E18 is 30 and cell I8 is 6:45 and my answer is
-23.75. Can I get this cell to format to -23:45 ? I am calculating Comp time
on a timesheet, so the number can be positive or negative.

Thanks,
Steve