subtract hours, not time of day

[Guest]

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

 

[Bob Phillips]

=IF(E18>I8,"-","")&TEXT(ABS(I8-E18/24),"[h]:mm")

--

HTH

RP
(remove nothere from the email address if mailing direct)