Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|