Help with Hr. Min formula
 

Hi there,

I need to show a certin time (1Hr 30 Mins) in Cell D3 as a negative
amount so that as time is inserted in other cells C4 to C10 the total
at the bottom of the sheet D12 will take into account D3

Cell D3 is formatted Custom [hr]:mm and i am using Excel 2003

Help would be greatly appreciated

Dennis

Help with Hr. Min formula
 

Change the sheet date system to the 1904 date system Tools Options
Calculation place a check in the 1904 date system. Just be warned that
this will change all dates by four yeas and one day.

An alternative would be to put 1 positive 1:30 : in D3 and then use:

=IF(SUM(D1:D11)-D3*20,SUM(D1:D11)-D3*2,"")

which will show onlt positive times.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Dent" wrote in message
...


Hi there,

I need to show a certin time (1Hr 30 Mins) in Cell D3 as a negative
amount so that as time is inserted in other cells C4 to C10 the total
at the bottom of the sheet D12 will take into account D3

Cell D3 is formatted Custom [hr]:mm and i am using Excel 2003

Help would be greatly appreciated

Dennis

Help with Hr. Min formula
 

On Mon, 26 May 2008 19:21:17 +0100, "Sandy Mann"
wrote:

Change the sheet date system to the 1904 date system Tools Options
Calculation place a check in the 1904 date system. Just be warned that
this will change all dates by four yeas and one day.

An alternative would be to put 1 positive 1:30 : in D3 and then use:

=IF(SUM(D1:D11)-D3*20,SUM(D1:D11)-D3*2,"")

which will show onlt positive times.


Yes I have it sorted now, never knew about the 1904 date system, many
thanks for your time and trouble

Dent