Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help - Need experts help!
I am having a problem with adding a column of time values and need an experts help! Column b has the time in and is formated as Time 13:00. Column c has the time out and is formated as Time 13:00. Column d adds the total time which has a formula of - =if(c10b10,c10-b10,1-(b10-c10)) Then I have Column d adding up to give me a total of time. It is formated as Number. The formula is g=sum(g8:g26)*24 This all works great as long as there is actual time entered. However when the cells in e & f as blank it still enters a total as it is taking it as 0:00 which it is counting it as 24:00 and adding this to the total. The formulas in b & c need to stay as is as this is the only way it will calculate ok if the b column is greater and the c column (ex: 18:00 as b and 6:00 as c) Can anyone tell me how to get around this problem? I would like to display the total as 0 if there are no times entered or blank. My spread sheet has 20 rows in which I can enter information if needed otherwise they sit blank.... Thanks -- rvnwdr ------------------------------------------------------------------------ rvnwdr's Profile: http://www.excelforum.com/member.php...o&userid=23903 View this thread: http://www.excelforum.com/showthread...hreadid=380839 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
for all of you excel experts | Excel Discussion (Misc queries) | |||
another for the experts | Excel Discussion (Misc queries) | |||
Question for the real experts! | Excel Discussion (Misc queries) | |||
Help from Dave Peterson - no disrespect to all other experts | Excel Discussion (Misc queries) | |||
Help from Dave Peterson - no disrespect to all other experts | Excel Discussion (Misc queries) |