View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dent Dent is offline
external usenet poster
 
Posts: 2
Default 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