Help with Hr. Min formula

D

Dent

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
:mm and i am using Excel 2003

Help would be greatly appreciated

Dennis
 
S

Sandy Mann

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*2>0,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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
D

Dent

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*2>0,SUM(D1:D11)-D3*2,"")

which will show onlt positive times.
Click to expand...


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

Dent
 
Top